Home » SQL & PL/SQL » SQL & PL/SQL » parameterised cursor or nested cursor
parameterised cursor or nested cursor [message #310454] Tue, 01 April 2008 05:54 Go to next message
smithagirish
Messages: 10
Registered: March 2008
Location: kochi
Junior Member
Hello

Can anyone please explain whether a parameterised cursor or a nested cursor is fast..


thanks in advance
Re: parameterised cursor or nested cursor [message #310462 is a reply to message #310454] Tue, 01 April 2008 06:28 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Depends on how your wrote the SQL statement inside cursor's definition.

Re: parameterised cursor or nested cursor [message #310463 is a reply to message #310454] Tue, 01 April 2008 06:30 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
from the sticky of this forum
Before you post anything in this forum be aware that this forum is meant for Expert PL/SQL problems.
This does NOT mean that experts only read this forum; 99% also read the Newbie-forum!

So, before posting here ask yourself the following:
- Do I consider myself an expert?
- Do I think the problem at hand is a difficult one?
- Is my problem strictly PL/SQL-related?

if you answer at least one of the above questions with "No" or "Don't know", find the appropriate forum here at OraFAQ.
If all three are answered "Yes", you are most welcome to post here!


Definitely does not qualify as Expert question!
Re: parameterised cursor or nested cursor [message #310636 is a reply to message #310463] Tue, 01 April 2008 20:52 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Try reading this: http://www.orafaq.com/node/1399
Previous Topic: generate result row
Next Topic: Can we override a function in PL/SQL environment
Goto Forum:
  


Current Time: Fri Dec 09 00:11:32 CST 2016

Total time taken to generate the page: 0.14439 seconds