Re: View problem...

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)

>

>

>