Re: how do you get DESCRIBE info for a view ?

> 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!
>

I dont understand what you want to see?

USER_TAB_COLUMNS has all information you need......no?

What do you mean by 'but I need to modify it to handle views'?

Regards, Stephan
--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------