Re: View problem...

Jimmy a écrit dans le message <37A10FB6.B64DBA3D_at_comp.polyu.edu.hk>...
>Hello all,
>
> I have a view in Oracle 7.3. I want to get the table name and the
>column name (of tables) of the view column refers. How can I get the
>above information by query the data dictionary? Or any other ways?
>
>Thanks,
>Jimmy
>

You can see the table and other objects referenced in a view with the view USER_DEPENDENCIES. Unfortunatly this wil not give you the columns.

desc USER_DEPENDENCIES

 Name                            Null?    Type
 ------------------------------- -------- ----
 NAME                            NOT NULL VARCHAR2(30)
 TYPE                                     VARCHAR2(12)
 REFERENCED_OWNER                         VARCHAR2(30)
 REFERENCED_NAME                 NOT NULL VARCHAR2(30)
 REFERENCED_TYPE                          VARCHAR2(12)
 REFERENCED_LINK_NAME                     VARCHAR2(128)