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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SET ROWCOUNT equivalant for Oracle 8?

Re: SET ROWCOUNT equivalant for Oracle 8?

From: Screamer <mflopes_at_mail.pt>
Date: Fri, 30 Jul 1999 21:50:31 +0100
Message-ID: <7nt39i$dfo$1@duke.telepac.pt>


That will query the first 10 records and return those that match the WHERE clause. coulb be 10, could be 0.

Gennaro Napolitano wrote in message <37A1B8D1.C05965AE_at_italdata.it>...
>Hy
>
>You can use the pseudocolumn rownum inside the where condition:
>
>SELECT ... FROM .. WHERE .... AND ROWNUM < 10;
>
>to get the first 10 records.
>
>Hope this helps
>
>Ciao Gennaro
>
>Seyed Razavi wrote:
>
>> Hi,
>>
>> After years of working with MS-SQL I need to develop a program (using
Java)
>> for an Oracle database. Is there a way of limiting the number of results
>> returned in the same manner as SET ROWCOUNT in MS-SQL? I am using Oracle
8
>> Enterprise version.
>>
>> Any help would be appreciated.
>>
>> --
>> Cheers,
>>
>> Seyed
>> seyed_at_kmpinternet.com
>> http://strata.kmpinternet.com/
>
Received on Fri Jul 30 1999 - 15:50:31 CDT

Original text of this message

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