Re: View problem...
From: Patrick Flahan <flahan_at_gte.net>
Date: Thu, 29 Jul 1999 16:00:08 GMT
Message-ID: <cU_n3.5$QU4.2066_at_paloalto-snr1.gtei.net>
Date: Thu, 29 Jul 1999 16:00:08 GMT
Message-ID: <cU_n3.5$QU4.2066_at_paloalto-snr1.gtei.net>
Try selecting against all_views (or user_views, dba_views, etc). One of the columns in the table contains the source sql code for the view and you can use that to determine where everything in the view comes from.
Hope that helps,
Patrick Flahan
flahan_at_earthlink.net
Jimmy <c6635500_at_comp.polyu.edu.hk> wrote in message
news: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 Thu Jul 29 1999 - 18:00:08 CEST