Re: View problem...

From: Tim Shute <tshute_at_nisoft.co.uk>
Date: Thu, 29 Jul 1999 14:12:54 +0100
Message-ID: <049F56710FD6D211B08D006097A4426B0DA77D@orion>

The nearest I can find is ALL_VIEWS.

--
--
Tim Shute
Software Engineering Manager

NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH Tel: +44 (0) 1232 814121, Fax: +44 (0) 1232 813962 Internet: www.nisoft.co.uk

Michel Cadot <micadot_at_altern.org> wrote in message news:7nph71$3lo$1_at_oceanite.cybercable.fr...
>
> 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 - 08:12:54 CDT