| non functioning of set pause on command [message #10102] |
Mon, 05 January 2004 19:52  |
ARANGASWAMY.V.
Messages: 29
Registered: April 2002
|
Junior Member |
|
|
I have a big table having lot of columns.
To see the columns and its datatype, I used DESCRIBE command.
Only the last few columns I could see.
Even the SET PAUSE ON command could stop the scrolling.
I have ORACLE 8i running on UNIX.
The only way to see the columns of such big table appears to be use of SPOOL command.
Is it not possible to view all the columns by using SET command before DESC command.
Kindly enlighten me.
with thanks
Aranga.V
|
|
|
|
| Re: non functioning of set pause on command [message #10107 is a reply to message #10102] |
Mon, 05 January 2004 20:59  |
 |
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
I believe that SET PAUSE only affects SQL commands like SELECT, not SQL*Plus commands like DESCRIBE. Perhaps you can select whatg you need from user_tab_columns:
SELECT column_name FROM user_tab_columns WHERE table_name = UPPER ('&tablename')
/
Also, make sure your pagesize is set low enough.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
