Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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=3D'ALL_VIEWS'; no rows selected
SELECT * FROM COL WHERE TNAME=3D'DBA_TABLES'; no rows selected
This will work from ALL_TAB_COLUMNS:
SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME =3D '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
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-> <-> For 380+ Oracle tips, visit: <-> <-> <-> <-> www.arikaplan.com <-> <-> <-> <-> email: akaplan_at_interaccess.com <-> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
On Fri, 18 Aug 2000, Rachel Carmichael wrote:
> Ari,
>=20
>=20 >=20
>=20 >=20> >
> >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
>=20
>=20> To REMOVE yourself from this mailing list, send an E-Mail message
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
--=20
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 Received on Fri Aug 18 2000 - 22:05:00 CDT