Michael's method does not work for the DESC command. The description of a table or
view (or procedure, etc.) will scroll off of the screen even if PAUSE is set.
The only method I use is to SPOOL to a file, do the DESCRIBE, and then SPOOL off. You
can then view the contents of the file.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 105+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Michael Serbanescu (mserban@postoffice.worldnet.att.net) wrote:
: Try this:
:
: SET PAGESIZE 23
: SET PAUSE "Press Return to continue"
:
: To see the next screen, press Return.
:
: Hope this helps.
:
:
:
: Michael Serbanescu
: ---------------------------------------------------------------------
: Vinay Gidwani wrote:
: >
: > From the SQL> prompt, I type in desc tablename to describe a table and the
: > table description scrolls on the screen. Is there a way such that the
: > table is displayed one screenful at a time?
: >
: > Any pointers would be helpful.
: >
:
: > Thanks
: >
: > Vinay.
Back to Ari Kaplan's Home Page