OraFAQ Forum: Client Tools

Home » Other » Client Tools » sql-query (9.0.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql-query [message #293094]

Thu, 10 January 2008 21:26

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Hi All, I have the following issue. Can you pls help me in this issue.

I have 100 records in one table.i want to display 10 rows at time and 
when i press any of the key(enter)  from  the keyboard then next 10 then next 10 like that.

Thank you,

Report message to a moderator

Re: sql-query [message #293097 is a reply to message #293094]

Thu, 10 January 2008 22:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> SET PAGESIZE 10 PAUSE ON

Report message to a moderator

Re: sql-query [message #293098 is a reply to message #293097]

Thu, 10 January 2008 22:12

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Thank you very much.

Report message to a moderator

Previous Topic:	SQL16W95.DLL General Protection Fault on Win XP
Next Topic:	Unable to connect

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 26 11:21:50 CDT 2025