Re: Learning Cursors

DA Morgan ha escrito:

> PHernandez wrote:
>
> > I have a follow up question on this, if I have a query that returns > 1
> > row and I'd want to display the result in a gui of some sort, e.g. a
> > web-page- I'm pretty much stuck with a cursor, right? Or are there
> > other ways to do it?
> >
> > --ph
> >
> > Oracle 10g
>
> Stuck with is the wrong way to approach it. What you need is a REF
> CURSOR and we are talking about one single line of code. If that is
> too much of a burden then perhaps coding isn't for you.

What's going on here, did you assume that my question was some kind of personal attack? Well, it wasn't.

The reason was that since Kyte says "if you can't do it with sql, then do it with pl/sql...", I was simply trying it the other way around, sortof "If it can be done with pl/sql, then maybe it can be done nicer with sql".

I'm trying to improve my code, thus coding is not for me?

Anyway, the question was not very well written so I guess the blame is on me.

> For a demo of REF CURSORs go to Morgan's Library at www.psoug.org
> and scroll down until you find the link.
>
> The site also contains demos of explicit cursors and the far superior
> array processing methodology (look under Bulk Collection).

Yes, I'm aware of this, but thanks!

--ph Received on Thu Feb 23 2006 - 12:17:55 CST