Need help with this SQL-Script
From: MikeG <mig_at_mail.com>
Date: 23 Apr 1999 11:27:35 GMT
Message-ID: <7fplf7$9g9$1_at_newsread.f.de.uu.net>
Hi all,
Date: 23 Apr 1999 11:27:35 GMT
Message-ID: <7fplf7$9g9$1_at_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 - 13:27:35 CEST