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: Cursors using SQL plus

Re: Cursors using SQL plus

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Tue, 16 Apr 2002 20:04:14 GMT
Message-ID: <3CBC83B8.ADE59927@exesolutions.com>


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

Original text of this message

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