Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: how do you get DESCRIBE info for a view ?
Try all_tab_columns.
There are three levels of dictionary views
all views starting with user: will show info on the objects you created
all views starting with all : will show info on all the objects you have
access to.
all views starting with dba : will show info on all objects in the database.
Hth,
Sybrand Bakker, Oracle DBA
Allen <allen.brost_at_motorola.com> schreef in berichtnieuws
3905E9BE.C3991729_at_motorola.com...
> 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
![]() |
![]() |