Re: How to display full text of views

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1995/04/14
Message-ID: <3mmlej$52k_at_dcsun4.us.oracle.com>#1/1


johns_at_adwyer.gsfc.nasa.gov (Steve Johns) wrote:
>
> 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.
>
>

you need to issue:

SQL> set long 5000
SQL> select text from user_views;

The "5000" can be any number. It dictates how many bytes of a long datatype sql*plus will retrieve and display.

Thomas Kyte
tkyte_at_us.oracle.com Received on Fri Apr 14 1995 - 00:00:00 CEST

Original text of this message