Re: code that created the view

Bricklen <bricklen-rem_at_yahoo.comz> wrote:

>D. Alvarado wrote:
>
>> What is/are the data dictionary table(s) used to discover what query
>> comprises a particular view?
>>
>> Thanks, - Dave
>
>select text from dba_views where view_name='view name';

IIRC, to see all the text, use a
set long=20000 ( or some big number) before the query.. the Text field is a LONG type..

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)