how do you get DESCRIBE info for a view ?

From: <sanity_prevails_at_my-deja.com>
Date: Wed, 05 Apr 2000 22:15:12 GMT
Message-ID: <8cgdt3$tkk$1@nnrp1.deja.com>

Does anyone know how to get at the meta-data information for an Oracle view in a form similar to that returned by DESCRIBE ?

I don't want the SQL text -- rather, I'd like to have some data dictionary stuff to be able to look at (e.g. like USER_TAB_COLUMNS etc. but for views). Is there a PL/SQL routine I can call? Anything new in Oracle 8i for this?

Basically, I have a program that crunches USER_TAB_COLUMNS but I need to modify it to handle views.

How the heck does Oracle SQL*Plus do it?

Thanks in advance!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 05 2000 - 17:15:12 CDT