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;