Just a tip:
I case the table contains too many rows the following
will save some time:
select count(*) from Table_1 where rownum=1;
If it returns 1 then the table has row(s) inside it, if 0 then it's empty. It'll run really fast since it checks only the first row.
Thanks.
Syed




Reply With Quote