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!

Query a table and exit when first record found

704459Oct 2 2009 — edited Oct 2 2009

I want to query a table and just want to know if any rows matching my query criteria exist in the table. I just want to find one row, irrespective of order and stop the query right there. How do I do that?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2009

Added on Oct 2 2009

11 comments

3,542 views