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

Thanks for the info. USER_TAB_COLUMNS was the ticket! Unfortunately I have one other problem. I found that another user (the one that did not create the table) cannot view the information. I have tried a few things and come to the same conclusion, the user has to be the one that created the table to run and view this "view".

Somebody prove me wrong and show me the light. Please!

Paul Druker wrote:

> Actually, USER_TAB_COLUMNS view contains information for table AND views.
>
> <sanity_prevails_at_my-deja.com> wrote in message
> news:8cgdt3$tkk$1_at_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 Tue Apr 25 2000 - 00:00:00 CDT