SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best way to see that the table has atleast one Row

183094Jan 25 2002

Hi,

Please let me know the best way to check if data exists in a table.

I don't want to use PL/SQL. I need an SQL statement.

For the time being I am using "Select count(*) from Table" to check data existence. It is too costly if we have Huge tables.

Thanks
Sunil

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 22 2002

Added on Jan 25 2002

2 comments

300 views