Re: how to retrieve view definition

From: <sybrandb_at_my-deja.com>
Date: Fri, 22 Dec 2000 15:00:18 GMT
Message-ID: <91vq9v$a1a$1@nnrp1.deja.com>

In article <91vpbg$94b$1_at_nnrp1.deja.com>, shdu_at_my-deja.com wrote:
> How do I retrieve view definition from SQLPLUS? I tried to "select
text
> from all_views where view_name='MY_VIEW'" but the returned text was
too
> long to display on a single line and was truncated. I tried to 'set
wrap
> on' but it did not help.
>
> Thanks.
>
> SF
>
> Sent via Deja.com
> http://www.deja.com/
>

View definitions are stored as longs.
Use
set long <anynumber>
and they will be displayed correctly.

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/

Received on Fri Dec 22 2000 - 09:00:18 CST