Re: Which table holds the view cols?
From: Martin Doherty <martin.doherty_at_elcaro.moc>
Date: Fri, 15 Nov 2002 13:01:15 -0800
Message-ID: <jkdB9.8$GH3.160_at_news.oracle.com>
Date: Fri, 15 Nov 2002 13:01:15 -0800
Message-ID: <jkdB9.8$GH3.160_at_news.oracle.com>
I wonder what SQL*Plus looks at when you ask it to DESCRIBE <view_name>?
Martin
Sybrand Bakker wrote:
>On Fri, 15 Nov 2002 10:24:25 -0800, Praveen
><p-nospam-mohanan_at_directvinternet.com> wrote:
>
>
>
>>Hi..All,
>>
>> When a user creates a table, all_tab_columns/user_tab_columns holds the
>>list of columns. When we create view, the all_views table hold only the text of
>>the view when it was generated. Which table holds the name of the columns of the
>>view?
>>
>>TIA
>>
>>P/
>>
>>
>
>
>There simply is no such view.
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
>
>
Received on Fri Nov 15 2002 - 22:01:15 CET