Re: Data Dictionary View for View Columns?

Short of looking at the long field and parsing it(yea its a nightmare and you cant use normal sql) but i'm sure i'm not telling you anythign you dotn already know :). i dont think it exists, i think all oracle does is set something in *dependencies so it knows that if ddl happens against the object, that the view needs to potentially be recompiled.

if you find something i'd be glad to know it also :)

thanks, joe

Ari D Kaplan wrote:
>
> 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).

-- 
Joe Testa  http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs