|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
output 1 page at a time
When I run 'select' statements the output does not fit on screen. How can I have my statement display 1 page at a time. Like the UNIX 'more' command.
TIA, VADA |
|
#2
|
|||
|
|||
|
for example your want to display 100 lines at a time, type the following SQL*Plua command on sql prompt
SQL>SET PAGESIZE 100 SQL>SET PAUSE ON the above code will wait until you press enter for every page. if you output does not fit into a screen so you can also only set the page size as much as you want (range between 0-50000) then you can scroll up and down. |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > output 1 page at a time |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|