Re: Data Dictionary View for View Columns?

Ari, I don't know about you, but besides giving you the wrong answer (I did know it was dba_tab_columns, sheer exhaustion, it's been a hellacious week)....I've been messing up my work laptop -- to the point I can't even log onto it.

Think someone was trying to tell me I was NOT supposed to work this weekend?

>From: Ari D Kaplan <akaplan_at_interaccess.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Data Dictionary View for View Columns?
>Date: Fri, 18 Aug 2000 19:05:01 -0800
>
>Hi Rachel
>
>(What are we doing on Friday night, oy!)
>
>Unfortunately, DBA_TABLES does not contain information on views. I found
>out from the list that DBA_TAB_COLUMNS (and
>ALL_TAB_COLUMNS/USER_TAB_COLUMNS)
>contain information on view columns.
>
>Someone on the list said (with a sigh) that COL does include views, but I
>still cannot get it to work:
>
>SELECT * FROM COL WHERE TNAME='ALL_VIEWS';
>
>no rows selected
>
>SELECT * FROM COL WHERE TNAME='DBA_TABLES';
>
>no rows selected
>
>This will work from ALL_TAB_COLUMNS:
>
>SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'DBA_TABLES';
>(many rows returned)
>
>Also, looking at the "sql.bsq" I was able to deduce info on the COL$ and
>OBJ$ that includes view column information.
>
>Take care, and thanks again to everyone's input today.
>
>-Ari Kaplan
>Independent Oracle DBA Consultant
>
><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
><-> For 380+ Oracle tips, visit: <->
><-> <->
><-> www.arikaplan.com <->
><-> <->
><-> email: akaplan_at_interaccess.com <->
><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
>On Fri, 18 Aug 2000, Rachel Carmichael wrote:
>
> > Ari,
> >
> > dba_tables
> >
> >
> > Rachel
> >
> >
> > >From: Ari D Kaplan <akaplan_at_interaccess.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: Data Dictionary View for View Columns?
> > >Date: Fri, 18 Aug 2000 10:49:25 -0800
> > >
> > >Does anyone know the data dictionary view (or table) that has the list
>of
> > >the columns and datatypes that comprise a view? I can get the syntax
>for
> > >the view's SQL (in ALL_VIEWS, VIEW$) and the number of columns (VIEW$),
> > >but not the actual individual columns and datatypes.
> > >
> > >I am looking for something similar to COL but for views, and am coming
>up
> > >empty.
> > >
> > >Thanks,
> > >
> > >-Ari
> > >
> > >--
> > >Author: Ari D Kaplan
> > > INET: akaplan_at_interaccess.com
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>--
>Author: Ari D Kaplan
> INET: akaplan_at_interaccess.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).