OraFAQ Forum: SQL & PL/SQL » Cursor loop performance

Home » SQL & PL/SQL » SQL & PL/SQL » Cursor loop performance

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cursor loop performance [message #39374]

Fri, 12 July 2002 06:31

helen
Messages: 13
Registered: September 2000

Junior Member

Hi
Which is more efficient, a cursor for loop or an open/fetch/close loop, assuming the functionality is the same? I think it's the cursor for loop as the parse and first fetch is done in one transaction, but I can't find any supporting documentation.
Do you have any ideas?
Thanks in advance
Helen

Report message to a moderator

Re: Cursor loop performance [message #39376 is a reply to message #39374]

Fri, 12 July 2002 07:27

Jon
Messages: 483
Registered: May 2001

Senior Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:1043086::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1205168148688,%7Bcursor%7D%20and%20%7Bfor%7D%20and%20%7Bloop%7D

Report message to a moderator

Cursor loop performance [message #40285 is a reply to message #39374]

Tue, 24 September 2002 05:38

Sohail Ahmed
Messages: 3
Registered: September 2002

Junior Member

How to pass Null value to a stored procedure using FOR CURSOR

Report message to a moderator

Re: Cursor loop performance [message #40286 is a reply to message #39374]

Tue, 24 September 2002 05:49

Sohail Ahmed
Messages: 3
Registered: September 2002

Junior Member

Cant we take argument as target

Report message to a moderator

Previous Topic:	create a procedure dynamic in another procedure???
Next Topic:	Re: Using MERGE for INSERT & Invalid Column Error.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 03:59:35 CDT 2024