Re: How to get whole text from DBA_VIEWS?

From: Frank <fbortel_at_nescape.net>
Date: Fri, 19 Dec 2003 19:18:40 +0100
Message-ID: <brvesv$j6i$1@news2.tilbu1.nb.home.nl>

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.

-- 
Merry Christmas and a Happy New Year,
Frank van Bortel

Received on Fri Dec 19 2003 - 12:18:40 CST