Re: Problem qith querying View source

>> I found an option which works on console :

>> If one sets the long value it is possible to get the whole text on the
>> console :

>> SQL> set long 1000
>> SQL> select text from dba_views where view_name = 'DBA_REGISTRY';

Yes, the LONG parameter dictates how much of a LONG datatype column gets displayed. DBA_VIEWS.TEXT is of type LONG, as you know:

SQL> desc dba_views;

Name                                      Null?    Type
----------------------------------------- -------- ----------------
OWNER                                     NOT NULL VARCHAR2(30)
VIEW_NAME                                 NOT NULL VARCHAR2(30)
TEXT_LENGTH                                        NUMBER
TEXT                                               LONG
TYPE_TEXT_LENGTH                                   NUMBER
TYPE_TEXT                                          VARCHAR2(4000)
OID_TEXT_LENGTH                                    NUMBER
OID_TEXT                                           VARCHAR2(4000)
VIEW_TYPE_OWNER                                    VARCHAR2(30)
VIEW_TYPE                                          VARCHAR2(30)
SUPERVIEW_NAME                                     VARCHAR2(30)

LONG defaults to 80.

HTH -g Received on Thu Mar 09 2006 - 10:27:40 CST