Re: SET ROWCOUNT equivalant for Oracle 8?

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 - 09:38:09 CDT