| 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_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_at_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_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_01C00962.F6E6A3F0 Content-Type: text/html; charset="iso-8859-1"Received on Fri Aug 18 2000 - 17:23:35 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: Data Dictionary View for View Columns?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>dba_tab_columns, all_tab_columns and user_tab_columns contain the ssame data for tables and views.</FONT>
</P>
<P><FONT SIZE=2>Alex Hillman</FONT>
</P>
<P><FONT SIZE=2>Alex Hillman</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Ari D Kaplan [<A HREF="mailto:akaplan_at_interaccess.com">mailto:akaplan_at_interaccess.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, August 18, 2000 2:49 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Data Dictionary View for View Columns?</FONT>
</P>
<BR>
<P><FONT SIZE=2>Does anyone know the data dictionary view (or table) that has the list of</FONT>
<BR><FONT SIZE=2>the columns and datatypes that comprise a view? I can get the syntax for</FONT>
<BR><FONT SIZE=2>the view's SQL (in ALL_VIEWS, VIEW$) and the number of columns (VIEW$),</FONT>
<BR><FONT SIZE=2>but not the actual individual columns and datatypes.</FONT>
</P>
<P><FONT SIZE=2>I am looking for something similar to COL but for views, and am coming up</FONT>
<BR><FONT SIZE=2>empty.</FONT>
</P>
<P><FONT SIZE=2>Thanks,</FONT>
</P>
<P><FONT SIZE=2>-Ari</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Ari D Kaplan</FONT>
<BR><FONT SIZE=2> INET: akaplan_at_interaccess.com</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
 |
 |