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 -> Re: How to get whole text from DBA_VIEWS?

Re: How to get whole text from DBA_VIEWS?

From: Frank <fbortel_at_nescape.net>
Date: Fri, 19 Dec 2003 17:31:48 +0100
Message-ID: <brv8kj$362$1@news2.tilbu1.nb.home.nl>


NoName wrote:

>>Open an SQL Window, type the query, Execute (F8) and use
>>Next Page (Alt+PgDn) or Last Page (Alt+End).

>
>
> Hi Frank,
> thank you for your reply,
> your suggestion works fine using PL/SQL Developer (I usually right-click the
> view name, and choose "view source"), but I wonder how to read the source of
> a view without this wonderful tool, simply using the standard SQLplus
> command...
>
> Regards
>
>

As TurkBear replied: set long 1000 (or 2000, or 4000 - depending on how many characters you want) before you execute the query
-- 
Merry Christmas and a Happy New Year,
Frank van Bortel
Received on Fri Dec 19 2003 - 10:31:48 CST

Original text of this message

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