OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » oracle pl/sql

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

oracle pl/sql [message #577570]

Mon, 18 February 2013 09:53

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?

Report message to a moderator

Re: oracle pl/sql [message #577571 is a reply to message #577570]

Mon, 18 February 2013 10:03

BlackSwan
Messages: 20087
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".

Report message to a moderator

Re: oracle pl/sql [message #577574 is a reply to message #577570]

Mon, 18 February 2013 10:13

Michel Cadot
Messages: 54142
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

Report message to a moderator

Re: oracle pl/sql [message #577788 is a reply to message #577574]

Wed, 20 February 2013 10:25

Bill B
Messages: 985
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 10:37:10 CDT 2013

Total time taken to generate the page: 6.00831 seconds