Re: Data Dictionary View for View Columns?

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Sat, 19 Aug 2000 01:20:42 GMT
Message-Id: <10593.115034@fatcity.com>

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 Received on Fri Aug 18 2000 - 20:20:42 CDT