Re: View problem...
From: Madhu Shekar <sudip.roy_at_in.bosch.com>
Date: 30 Jul 1999 08:27:08 GMT
Message-ID: <01beda65$1727f800$1c0394ad_at_qcs_07_95w.ban.india.bosch.com>
Date: 30 Jul 1999 08:27:08 GMT
Message-ID: <01beda65$1727f800$1c0394ad_at_qcs_07_95w.ban.india.bosch.com>
hello
Use the Data Dictionary ALL_VIEWS to query the Tables and Columns. The Query goes Like this: select Text from all_views where view_name = 'MY_VIEW' In case the View Defination is too long,use SET LONG command to Change the text length. Hope This Gives your Answer. Madhu.
Jimmy <c6635500_at_comp.polyu.edu.hk> wrote in article
<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
>
>
Received on Fri Jul 30 1999 - 10:27:08 CEST