Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: What's the equivalent of "set rowcount 10"(ms sql) in oracle?

Re: What's the equivalent of "set rowcount 10"(ms sql) in oracle?

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Fri, 11 Dec 98 21:51:53 +0200
Message-ID: <AIPVNSsK42@protasov.kiev.ua>

Hi,

Try

select * from <your_table> where rownum<=10;

Andrew Protasov

> hi..
> i just want to know above......
> help me...
>
>
>
Received on Fri Dec 11 1998 - 13:51:53 CST

This message: [ Message body ]
Next message: Andrew Protasov: "Re: Memory Leak Oracle 8.0"
Previous message: Thomas Kyte: "Re: Conversion tool from SQL Server to Oracle"
In reply to: Lexus: "What's the equivalent of "set rowcount 10"(ms sql) in oracle?"
Next in thread: Amit Aggarwal: "Re: What's the equivalent of "set rowcount 10"(ms sql) in oracle?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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