Re: Which table holds the view cols?

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Mon, 18 Nov 2002 10:01:46 -0600
Message-ID: <2h3itusq5u1n8p79c6ghkm64s84jccci1d_at_4ax.com>


The TEXT column of all_views ( or user_views) has the code that created the view which shows which columns are in it..

See below:

SQL> create view hr_data_v as select * from hr_public;
SQL> set long 2000
SQL> select text from user_views where view_name = 'HR_DATA_V';

TEXT


select "DEPT_NBR","EMPL_NM","EMPL_NBR","LOCN_NM","JOB_DESC","MAIL_DROP_ADDR","WO
RK_PHONE_NBR","OFFICE_NM","WORK_PHONE_EXT_NBR","LAST_UPDATE","CELL_PHONE_NBR","F
AX_PHONE_NBR","NTWK_PHONE_NBR","TDD_PHONE_NBR","STREET1_ADDR","STREET2_ADDR","ZI
P_CD","INTERNET_ADDR","EMPL_REC_NBR","AGENCY_SRVC_BEG_DT","UNION_CD","CITY_NM"," POSN_NBR","EMPL_STAT_CD","JOB_CD","ORGN_NBR","UNION_DESC","USER_ID","SUPERVISOR_ ID","GROUP_NM","CONCATNAME","FIRST_NM","LAST_NM","ZCODE","OT_LINK","EMPL_MIDDLE_ NM" from hr_public
-
hth,

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/
Received on Mon Nov 18 2002 - 17:01:46 CET

Original text of this message