Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: how do you get DESCRIBE info for a view ?

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/25
Message-ID: <956690848.18869.0.pluto.d4ee154e@news.demon.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US