Re: How to display full text of views

In article <JOHNS.95Apr14154436_at_adwyer.gsfc.nasa.gov>, johns_at_adwyer.gsfc.nasa.gov says...
>
>This statement:
>
>select text from user_views;
>
>is giving me results like this:
>
>select de_source.de_id, source_map.source_short, source_map.source_name
> from md
>
>
>for a view that was created like this:
>
>create view source_name(de_id, source_short, source_name) as
> select de_source.de_id, source_map.source_short, source_map.source_name
> from mddba.source_map, mddba.de_source
> where source_map.source_name = de_source.source_name;
>
>
>Where is the rest of my text? How can I see it? I feel like I'm
>missing something obvious.
>
>

The default displaylength of LONG is not very long. Try using SQL> SET LONG 1000
to get more of your source. BTW Often the ARRAYSIZE has to be redused when fetching wide records from sqlplus.

/Wilhelm Olander Received on Mon Apr 24 1995 - 00:00:00 CEST