Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create cursors?
You don't need a loop, you need a view.
Read SQL Language documentation.
In article <90r9fh$tgl$1_at_nnrp1.deja.com>,
twoplustwo_at_my-deja.com wrote:
> 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.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Dec 08 2000 - 16:33:40 CST