Re: DESC tables

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:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Michael Serbanescu (mserban_at_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.
  Received on Thu Sep 18 1997 - 00:00:00 CDT