Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Need help with this SQL-Script
Hi all,
I try to select all SQL-Scripts used to create a view with following statement
select owner, text from all_views there owner='MISDBA'
The problem is that the result set for each row of text column is very long, so that I can't see the whole result, because it end's by 2000 bytes.
Does anyone knows a possibiliy to spool the whole result set ???
Thanx
Mike Received on Fri Apr 23 1999 - 05:37:45 CDT
![]() |
![]() |