Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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 CDT
![]() |
![]() |