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: Alex Filonov <afilonov_at_pro-ns.net>
Date: Fri, 08 Dec 2000 22:33:40 GMT
Message-ID: <90rnk5$9qe$1@nnrp1.deja.com>

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

Original text of this message

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