| SQL Output [message #2970] |
Tue, 27 August 2002 02:43  |
eela
Messages: 7
Registered: June 2002
|
Junior Member |
|
|
I am running a query :
'select text from user_views '
As i want the script for the user created views but problem is that only few lines of the view gets printed on the SQL pLUS
I have tried many page size,line size and array size increment options but all in vain .
Can anybody help me.
|
|
|
|
| Re: SQL Output [message #2974 is a reply to message #2970] |
Tue, 27 August 2002 09:04  |
Wijnand
Messages: 11
Registered: March 2002
|
Junior Member |
|
|
if you do a DESC user_views you will see that TEXT is a LONG field. They can be, as the name suggests, very long.
if you state
select max(length) from user_views;
You will see how long it can be.
If you state
SET LONG = 1000
before the query, you will see more.
If you state
SET WRAP ON
before the query, you will see even more, and it will be readable.
My suggestion is to
SET LONG to the maximum length,
SET WRAP ON
SPOOL yourfile
select * from user_views;
SPOOL OFF
and examine the spool file.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
