Re: How to display full text of views
Date: 1995/04/26
Message-ID: <3nlr4o$1n1a_at_rover.ucs.ualberta.ca>#1/1
wo_at_dialog.se (Wilhelm Olander) writes:
>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.
create view source_name(de_id, source_short, source_name) as {CR}
select de_source.de_id, {CR} source_map.source_short, {CR} source_map.source_name {CR} from mddba.source_map, mddba.de_source {CR} where source_map.source_name = de_source.source_name;Received on Wed Apr 26 1995 - 00:00:00 CEST