Re: Which table holds the view cols?
From: Frank Diedrich <fdi_at_gmx.de>
Date: Fri, 15 Nov 2002 22:42:33 +0100
Message-ID: <ar3pql$889$04$1_at_news.t-online.com>
Date: Fri, 15 Nov 2002 22:42:33 +0100
Message-ID: <ar3pql$889$04$1_at_news.t-online.com>
[Quoted] "Praveen" <p-nospam-mohanan_at_directvinternet.com> schrieb im Newsbeitrag
news:3DD53BD9.8090005_at_directvinternet.com...
> 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/
>
[Quoted] Try also all_tab_colums and take view:name for table_name...
Greetings,
Frank Received on Fri Nov 15 2002 - 22:42:33 CET