| Display on SQL Plus [message #102417] |
Sun, 26 May 2002 23:31  |
mandar rajurkar
Messages: 1
Registered: May 2002
|
Junior Member |
|
|
I want my result displayed on the SQL*Plus prompt to stop pagewise if it in multipages.
I would be able to manually intervene and see next page's result by pressing some key.
|
|
|
|
| Re: Display on SQL Plus [message #102418 is a reply to message #102417] |
Mon, 27 May 2002 08:13  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
use
sql> set pause on
the screen will be scrolled to next page when u hit "enter" or carriage return.
Note:
you can define you own SIZE for the page
by
sql> set pagesize 25
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
