Re: View problem...

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 - 08:32:08 CDT