Re: View problem...
From: Michel Cadot <micadot_at_altern.org>
Date: Thu, 29 Jul 1999 14:24:23 +0200
Message-ID: <7nph71$3lo$1_at_oceanite.cybercable.fr>
Date: Thu, 29 Jul 1999 14:24:23 +0200
Message-ID: <7nph71$3lo$1_at_oceanite.cybercable.fr>
[Quoted] 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)Received on Thu Jul 29 1999 - 14:24:23 CEST