Re: View problem...
From: Peter Whyte <zephyr_at_uq.net.au>
Date: Fri, 30 Jul 1999 23:32:08 +1000
Message-ID: <37A1A958.4BDD59E4_at_uq.net.au>
Date: Fri, 30 Jul 1999 23:32:08 +1000
Message-ID: <37A1A958.4BDD59E4_at_uq.net.au>
Hi Jimmy,
use all_views to select the sql text which defined the view.
Peter
Jimmy wrote:
>
> 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 - 15:32:08 CEST