Home » SQL & PL/SQL » SQL & PL/SQL » oracle pl/sql
oracle pl/sql [message #577570] Mon, 18 February 2013 09:53 Go to next message
azpl/sql
Messages: 1
Registered: February 2013
Junior Member
I have a oracle cursor. I need to find whether that cursor has a only the value I a looking for. If it has that value then i need to do some actions. How do i perform this logic within a cursor?
Re: oracle pl/sql [message #577571 is a reply to message #577570] Mon, 18 February 2013 10:03 Go to previous messageGo to next message
BlackSwan
Messages: 22712
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


a cursor is a pointer & never "has any value".
Re: oracle pl/sql [message #577574 is a reply to message #577570] Mon, 18 February 2013 10:13 Go to previous messageGo to next message
Michel Cadot
Messages: 58921
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So create/open the cursor for a query that returns only the value you want.

Regards
Michel
Re: oracle pl/sql [message #577788 is a reply to message #577574] Wed, 20 February 2013 10:25 Go to previous message
Bill B
Messages: 1085
Registered: December 2004
Senior Member
Look at CURSOR LOOPS. If the condition in the cursor is never satisfied the code inside the loop will never be accessed.

[mod-edit] change first word LOOP to LOOK. I think that is what Bill B meant.

[Updated on: Wed, 20 February 2013 12:44] by Moderator

Report message to a moderator

Previous Topic: Removing Leading single quote in excel file
Next Topic: job runs every 2 minutes, procedure works about 1,5 minutes
Goto Forum:
  


Current Time: Thu Aug 28 04:54:33 CDT 2014

Total time taken to generate the page: 0.15343 seconds