Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cursors using SQL plus
Control-C followed by Control-V.
You should always do this with every cursor to see how it EXPLAIN PLANs.
Daniel Morgan
Harry wrote:
> Hi all,
>
> I have really quick question.
>
> I'm debuging a hugh cursor in a piece of badly written code and
> what I am finding is that I'm spending too much time compiling
> the program and running it.
>
> What I want to do is to be able to run the cursor from the sql plus
> window, and see that data that comes out line by line.
>
> Is this possible? How?
>
> Also, since I have your attention:
> In the same cursor I want to lock the selected data using a FOR UPDATE
> OF clause. My documentation tells me this isn't allowed with cursors
> (we're running oracle 8.0.5 on HP-UX) but is there any other way?
>
> Thanking you all,
>
> Harry
Received on Tue Apr 16 2002 - 15:04:14 CDT