Share Your Thinking
Impossible is a word that itself i-m-possible.
24 January, 2010
Oracle Count(*) Return zero?
In Oracle, if a table have no records.
the select count(*) from tab_name;
return no records found.
How u return 0(zero)...........write the command?
select nvl(max(count(*)),0) from tab_namegroup by unique_key;
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment