Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to get whole text from DBA_VIEWS?
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 Received on Fri Dec 19 2003 - 03:24:37 CST