Scrolling Data [message #1254] |
Mon, 15 April 2002 06:35 |
Julie Zolnowski
Messages: 9 Registered: April 2002
|
Junior Member |
|
|
If I execute a query through a pl/sql window and it starts scrolling my data on screen - how do I pause the scrolling data so I can view it line by line if needed? Thanks.
|
|
|
Re: Scrolling Data [message #1262 is a reply to message #1254] |
Mon, 15 April 2002 11:08 |
obie-wan
Messages: 5 Registered: April 2002
|
Junior Member |
|
|
In SQL*Plus enter SET PAUSE ON. The query will pause every x PAGESIZE. If you set PAGESIZE to 24 you'll get a screen at at time. I set my logon.sql to do this. The SET PAUSE displays when it's time for the next page.
set heading off
set serveroutput on
select 'Instance '||name from v$database;
set heading on
set linesize 132 pagesize 24 verify off
set pause on
set pause "---Hit Enter to Continue---"
col fbytes format 999,999,999,999 heading bytes
|
|
|