Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Need help with this SQL-Script

Need help with this SQL-Script

From: MikeG <mig_at_mail.com>
Date: 23 Apr 1999 10:37:45 GMT
Message-ID: <7fpihp$63f$1@newsread.f.de.uu.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US