Re: How to get whole text from DBA_VIEWS?

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Fri, 19 Dec 2003 13:22:36 -0600
Message-ID: <arj6uv4b6rpnc121ev8o5l7estjeihmi6j@4ax.com>

Frank <fbortel_at_nescape.net> wrote:

>NoName wrote:
>
>>>In SqlPLus:
>>>
>>>set LONG 1000
>>>select text from DBA_VIEWS where owner='myowner' and view_name='myview';
>>
>>
>> Ahh, I was missing the SET LONG command!!
>> So, since the DBA_VIEWS has a column with the text length, using SET LONG
>> with the value in that column...
>>
>> Well, thank you, and happy Xmas holydays, to you and everybody here in this
>> newsgroup!
>>
>> Best Regards
>>
>>
>Ehhh - no, actually the text is stored in a datatype LONG
>column.

You can use the technique NoName used:

---

select text_length from all_views where view_name = 'QWHAP_VENDOR_NAME_V';

TEXT_LENGTH

---

        160

SQL> set long 160
SQL> select text from all_views where view_name = 'QWHAP_VENDOR_NAME_V';

TEXT

---

select "VENDOR_NBR","VNDR_1_NM","VNDR_2_NM","VNDR_3_NM","VNDR_LOCN_NBR","VNDR_NB R","VNDR_STAT_CD","VNDR_STAT_DESC" from qwhap.vendor_name_at_remotedb WITH READ ONLY

SQL>

---

Just enough chars allocated to hold the text. Received on Fri Dec 19 2003 - 13:22:36 CST