Home » SQL & PL/SQL » SQL & PL/SQL » Cursor Question (oracle 10g release 2)
Cursor Question [message #310940] Wed, 02 April 2008 21:29 Go to next message
horax
Messages: 34
Registered: March 2008
Member
I'm cursing a lot at cursors lately.

Can an explicit cursor actually process more than one line of code in a loop, or would it be best to utizilie the Cursor For Loop instead?

I've been trying to do something with teh explicit cursor, and I get a single output, but I need the block to loop and show the output for 20 different instances, not one.

If I'm doing the wrong thing, I'll be happy. If I'm doing something right, then I know something's wrong with my code design or mathematics, which would really tick me off!

hx
Re: Cursor Question [message #310944 is a reply to message #310940] Wed, 02 April 2008 22:03 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
http://asktom.oracle.com contains many fine coding examples

If you can solve the problem using SQL, then use only SQL.
If you can solve the problem using only SQL, then use PL/SQL.

Does GOOGLE search for oracle "bulk collect"
Results 1 - 10 of about 19,300
Re: Cursor Question [message #310975 is a reply to message #310940] Thu, 03 April 2008 00:20 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And if you want more complete answer, you have to post your code.
Don't forget to format when you'll post it.

Regards
Michel
Previous Topic: Timezone conversion
Next Topic: Temporary Tables
Goto Forum:
  


Current Time: Mon Dec 05 13:01:50 CST 2016

Total time taken to generate the page: 0.16104 seconds