Re: Syntax to return first record - Oracle ??

Have you considered using in your WHERE clause

Where ROWNUM < 2

actually, i set that to about 10 records when I'm testing a package, a form or a report.

I know the results may be inconsistent as the tables are updated and rows are inserted, but it sure helps out when you want at most a few records from a source table for debugging purposes. Received on Tue May 23 2000 - 00:00:00 CEST