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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to create cursors?

Re: How to create cursors?

From: Tom Leary <tleary1_at_uswest.net>
Date: Sun, 17 Dec 2000 01:41:41 -0800
Message-ID: <i5__5.3527$Ri6.501288@news.uswest.net>

u don't need any undocumented functions, just join dba_tables, dba_extents, dba_tables... to get what you need

"PelleSvanslös" <jamppi_at_telia.com> wrote in message news:z%L_5.4176$O%.675278_at_newsc.telia.net...
> hi !!
>
> i have the same problem that u have !!! did u solve it ??
> could u tell me how u did ??
>
> /Jarmo
>
>
> <twoplustwo_at_my-deja.com> skrev i meddelandet
> news:90r9fh$tgl$1_at_nnrp1.deja.com...
> > I would like to write a routine to loop through the 'Dba_table' and
> > pull out unique owners and table names. From there, I would like to
> > query infomration about rows, allocated space etc. What is the syntax
> > used to set up this type of loop... is there any undocumented functions
> > that will do this?
> >
> >
> > Thanks
> > TwoPlusTwo
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Sun Dec 17 2000 - 03:41:41 CST

Original text of this message

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