Home » Other » Client Tools » how to limit rows within SQLPlus
how to limit rows within SQLPlus [message #2525] Tue, 23 July 2002 12:24 Go to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
In MSSQL7's Query Analyzer tool, one can limit the number of rows returned from a SELECT statement via the following command: "SET ROWCOUNT 25", and only the first 25 rows will be returned. Is there a command or parameter to accomplish the same within SQLPlus? I tried "SET PAUSE ON", but it does not limit the number of rows returned. Thanks...

Report message to a moderator

Re: how to limit rows within SQLPlus [message #2526 is a reply to message #2525] Tue, 23 July 2002 12:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
select * from emp
where rownum < 20;

this sql delivers only first 20 rows.

Report message to a moderator

Re: how to limit rows within SQLPlus [message #2537 is a reply to message #2526] Wed, 24 July 2002 10:21 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Thanks again Mahesh!!

Report message to a moderator

Previous Topic: Spool Command
Next Topic: spool problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 01:28:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.