Message-Id: <10593.115021@fatcity.com> From: Alex Hillman Date: Fri, 18 Aug 2000 18:23:35 -0400 Subject: RE: Data Dictionary View for View Columns? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C00962.F6E6A3F0 Content-Type: text/plain; charset="iso-8859-1" dba_tab_columns, all_tab_columns and user_tab_columns contain the ssame data for tables and views. Alex Hillman Alex Hillman -----Original Message----- From: Ari D Kaplan [mailto:akaplan@interaccess.com] Sent: Friday, August 18, 2000 2:49 PM To: Multiple recipients of list ORACLE-L Subject: Data Dictionary View for View Columns? 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@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@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). ------_=_NextPart_001_01C00962.F6E6A3F0 Content-Type: text/html; charset="iso-8859-1" RE: Data Dictionary View for View Columns?

dba_tab_columns, all_tab_columns and user_tab_columns contain the ssame data for tables and views.

Alex Hillman

Alex Hillman

-----Original Message-----
From: Ari D Kaplan [mailto:akaplan@interaccess.com]
Sent: Friday, August 18, 2000 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Data Dictionary View for View Columns?


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@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@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).