Re: How to get whole text from DBA_VIEWS?

"NoName" <nobody_at_nowhere.com> wrote:

>I usually use the wonderful program "PL/SQL Develpoer" from
>AllAroundAutomation to magage Oracle (tables, views, packages, and so on).
>I admit that I rarely use native instructions using SQL*PLUS.
>
>So, I can easily get the source of a view in a couple of clicks, but I dont
>know how to get full text from DBA_VIEWS.
>
>That is, if I write the following:
>
>select text from DBA_VIEWS where owner='myowner' and view_name='myview';
>
>the result is the first 255 characters, and not the whole text.
>Can someone please give me a clue, where to find the solution on reference
>manuals?
>
>Thank you
>

In SqlPLus:

set LONG 1000
select text from DBA_VIEWS where owner='myowner' and view_name='myview';

should do it.

If not , increase the number. Received on Fri Dec 19 2003 - 08:31:26 CST