Re: View problem...

From: MickM <mickm_at_spirit.com.au>
Date: Fri, 30 Jul 1999 17:26:43 +1000
Message-ID: <37A153B3.44EE5383@spirit.com.au>

The two queries should help

select view_name, text from user_views where view_name = 'xxxx'; select column_name from user_tab_columns where table_name = 'xxxx';

where 'xxxx' refers to the view you are interested in.

Regards,
Mick

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 - 02:26:43 CDT