>SANITY WROTE
>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!
>
>Hi
DESC view_name;
gives same info as DESC table_name ie, columns, datatype.
hth
S
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>
>
>
>
>
>
Received on Wed Apr 05 2000 - 19:39:28 CDT
