Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Syntax to return first record - Oracle ??

Re: Syntax to return first record - Oracle ??

From: Eric Rouillard <eric.rouillard_sn_at_sympatico.ca>
Date: 2000/05/23
Message-ID: <3929E394.C523F3E@sympatico.ca>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US