NoName 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
>
>
Open an SQL Window, type the query, Execute (F8) and use
Next Page (Alt+PgDn) or Last Page (Alt+End).
--
Merry Christmas and a Happy New Year,
Frank van Bortel
Received on Fri Dec 19 2003 - 07:47:22 CST
