Re: getting full sql of a view

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 6 Apr 1999 06:32:57 +0200
Message-ID: <923373294.8402.0.rover.d4ee154e@news.demon.nl>

The reminder is to issue a
set long 1000 (or whatever)
before
select text
from dba_views.
It is there, but it is truncated because of the standard display length of a long in sql*plus.

Hth,

Sybrand Bakker, Oracle DBA

Ross Cuthbertson wrote in message <7ebmbi$7nl$1_at_mail.pl.unisys.com>...
>can someone remind me of how to get the full text of view. DBA_VIEWS only
>gies you the first 80 odd characters.
>
>Many thanks for any help
>
>Regards
>Ross Cuthbertson
>
>
Received on Mon Apr 05 1999 - 23:32:57 CDT