OracleConnections

Oracle Community Network

Cursor doubt

Hi all,

I have a doubt...

If'm usinfg an implicit cursor , then once i complete it , how i can execute it? is there any command to execute it or it gets automatically executed??

0 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Thanh Nino on June 11, 2013 at 12:05pm

You can do nothing with an imlicit cursor: Oracle does everything for you. That is what "implicit" means.

▶ Reply

Permalink Reply by Brooks Kottke on June 11, 2013 at 12:08pm

Hi,

I want the syntax for both implicit and explicit cursors with clear explaination. I'm getting in google but i'm not clear with that explaination given with that. please get back to me.

regards,

Brooks

▶ Reply

Permalink Reply by Thanh Nino on June 11, 2013 at 12:10pm

As I already told you, there is no such thing aws syntax for implicit cursors, because they are implicit. What did you find with Google for explicit cursors that you did not understand? And why don't you just read the PL/SQL documentation instead?

▶ Reply

Permalink Reply by Julian Caroll on June 11, 2013 at 12:14pm

When oracle engine opens a cursor for it's internal processing in order to execute an sql statement it is called implicit cursor.
so you need not to open,Fetch or close .