Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to get whole text from DBA_VIEWS?

How to get whole text from DBA_VIEWS?

From: NoName <nobody_at_nowhere.com>
Date: Fri, 19 Dec 2003 10:24:37 +0100
Message-ID: <brufdt$6em$1@fata.cs.interbusiness.it>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US