| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_01C00A17.736F86F0
Content-Type: text/plain;
charset="iso-8859-1"
So what do you need to find about the view that you cannot find in dba_views and dba_tab_columns?
Alex Hillman
-----Original Message-----
From: Ari D Kaplan [mailto:akaplan_at_interaccess.com]
Sent: Friday, August 18, 2000 11:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Data Dictionary View for View Columns?
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
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->> also send the HELP command for other information (like subscribing). >
<-> 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
-- 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). ------_=_NextPart_001_01C00A17.736F86F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Data Dictionary View for View Columns?</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>So what do you need to find about the view that you = cannot find in dba_views and dba_tab_columns?</FONT> </P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Ari D Kaplan [<A = HREF=3D"mailto:akaplan_at_interaccess.com">mailto:akaplan_at_interaccess.com</= A>]</FONT> <BR><FONT SIZE=3D2>Sent: Friday, August 18, 2000 11:05 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Data Dictionary View for View = Columns?</FONT> </P> <BR> <P><FONT SIZE=3D2>Hi Rachel</FONT> </P> <P><FONT SIZE=3D2>(What are we doing on Friday night, oy!)</FONT> </P> <P><FONT SIZE=3D2>Unfortunately, DBA_TABLES does not contain = information on views. I found</FONT> <BR><FONT SIZE=3D2>out from the list that DBA_TAB_COLUMNS (and = ALL_TAB_COLUMNS/USER_TAB_COLUMNS)</FONT> <BR><FONT SIZE=3D2>contain information on view columns.</FONT> </P> <P><FONT SIZE=3D2>Someone on the list said (with a sigh) that COL does = include views, but I</FONT> <BR><FONT SIZE=3D2>still cannot get it to work:</FONT> </P> <P><FONT SIZE=3D2>SELECT * FROM COL WHERE TNAME=3D'ALL_VIEWS';</FONT> </P> <P><FONT SIZE=3D2>no rows selected</FONT> </P> <P><FONT SIZE=3D2>SELECT * FROM COL WHERE TNAME=3D'DBA_TABLES';</FONT> </P> <P><FONT SIZE=3D2>no rows selected</FONT> </P> <P><FONT SIZE=3D2>This will work from ALL_TAB_COLUMNS:</FONT> </P> <P><FONT SIZE=3D2>SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME =3D = 'DBA_TABLES';</FONT> <BR><FONT SIZE=3D2>(many rows returned)</FONT> </P> <P><FONT SIZE=3D2>Also, looking at the "sql.bsq" I was able = to deduce info on the COL$ and</FONT> <BR><FONT SIZE=3D2>OBJ$ that includes view column information.</FONT> </P> <P><FONT SIZE=3D2>Take care, and thanks again to everyone's input = today.</FONT> </P> <P><FONT SIZE=3D2>-Ari Kaplan</FONT> <BR><FONT SIZE=3D2>Independent Oracle DBA Consultant</FONT> </P> <P><FONT = SIZE=3D2><-><-><-><-><-><-><->= <-><-><-><-><-><-><-><->= <-><-><-><-><-></FONT> <BR><FONT SIZE=3D2><-> For 380+ Oracle tips, = visit: = = <-></FONT> <BR><FONT = SIZE=3D2><-> = = = = <-></FONT> <BR><FONT = SIZE=3D2><-> = = www.arikaplan.com &= nbsp; &= nbsp; <-></FONT> <BR><FONT = SIZE=3D2><-> = = = = <-></FONT> <BR><FONT = SIZE=3D2><-> = email: = akaplan_at_interaccess.com &= nbsp; <-></FONT> <BR><FONT = SIZE=3D2><-><-><-><-><-><-><->= <-><-><-><-><-><-><-><->= <-><-><-><-><-></FONT> </P> <P><FONT SIZE=3D2>On Fri, 18 Aug 2000, Rachel Carmichael wrote:</FONT> </P> <P><FONT SIZE=3D2>> Ari,</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> dba_tables</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Rachel</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> >From: Ari D Kaplan = <akaplan_at_interaccess.com></FONT> <BR><FONT SIZE=3D2>> >Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>> >To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>> >Subject: Data Dictionary View for View = Columns?</FONT> <BR><FONT SIZE=3D2>> >Date: Fri, 18 Aug 2000 10:49:25 = -0800</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >Does anyone know the data dictionary view = (or table) that has the list of</FONT> <BR><FONT SIZE=3D2>> >the columns and datatypes that comprise a = view? I can get the syntax for</FONT> <BR><FONT SIZE=3D2>> >the view's SQL (in ALL_VIEWS, VIEW$) and = the number of columns (VIEW$),</FONT> <BR><FONT SIZE=3D2>> >but not the actual individual columns and = datatypes.</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >I am looking for something similar to COL = but for views, and am coming up</FONT> <BR><FONT SIZE=3D2>> >empty.</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >Thanks,</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >-Ari</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >--</FONT> <BR><FONT SIZE=3D2>> >Author: Ari D Kaplan</FONT> <BR><FONT SIZE=3D2>> > INET: = akaplan_at_interaccess.com</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >Fat City Network Services = -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> >San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = >--------------------------------------------------------------------= </FONT> <BR><FONT SIZE=3D2>> >To REMOVE yourself from this mailing list, = send an E-Mail message</FONT> <BR><FONT SIZE=3D2>> >to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> >the message BODY, include a line = containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> >(or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> >also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> = ________________________________________________________________________= </FONT> <BR><FONT SIZE=3D2>> Get Your Private, Free E-mail from MSN Hotmail = at <A HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Author: Rachel Carmichael</FONT> <BR><FONT SIZE=3D2>> INET: carmichr_at_hotmail.com</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>> </FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Ari D Kaplan</FONT> <BR><FONT SIZE=3D2> INET: akaplan_at_interaccess.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT>Received on Sat Aug 19 2000 - 14:55:40 CDT
 |
 |