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 ?
Awesome! Thanks for the help. Saved me many moons of pain.
I guess I should have known this, but sometimes the obvious evades us...
Sybrand Bakker wrote:
> 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