Home » SQL & PL/SQL » SQL & PL/SQL » Cursors.
Cursors. [message #234232] Mon, 30 April 2007 09:33 Go to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Hi all.

Can I create 2 cursors in my pl/sql program? If yes, do I have to open the first cursor then close it before open the second one?

Thank you.
Re: Cursors. [message #234238 is a reply to message #234232] Mon, 30 April 2007 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes. No.

Regards
Michel
Re: Cursors. [message #234258 is a reply to message #234238] Mon, 30 April 2007 11:08 Go to previous messageGo to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Hi.

Sorry. I did not understand what you meant 'yes.no'. Please tell me more details
Re: Cursors. [message #234263 is a reply to message #234258] Mon, 30 April 2007 11:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You posted 2 questions.
I answered yes to the first one.
I answered no to the second one.

Regards
Michel

Re: Cursors. [message #234271 is a reply to message #234263] Mon, 30 April 2007 12:09 Go to previous message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Thanks.
Previous Topic: Warning: Procedure created with compilation errors
Next Topic: Creating a 'grouping' view
Goto Forum:
  


Current Time: Thu Dec 08 22:27:30 CST 2016

Total time taken to generate the page: 0.09164 seconds