Home » SQL & PL/SQL » SQL & PL/SQL » need help in using cursors
need help in using cursors [message #251166] Thu, 12 July 2007 10:15 Go to next message
bharat0201
Messages: 15
Registered: June 2007
Junior Member
Hi,

Oracle version 10.0.2
unix AIX

I am stuck in coding the following part of code, i didnt execute the code at, i am in the process of writing.

so i couldnt follow the format of ORFAQ for this.

I need help in implementing this logic

Open A1 cursor
fetch data
(do some calculations on this data)
when no_data_found
THEN
open B1 CURSOR
FETCH DATA
(do calculations on this data)
WHEN NO_DATA_FOUND
THEN
OPEN C1 CURSOR
FETCH DATA
(do calculations on this data)

THANKS

[Updated on: Thu, 12 July 2007 10:32]

Report message to a moderator

Re: need help in using cursors [message #251171 is a reply to message #251166] Thu, 12 July 2007 10:23 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Format your post according to the guidelines.

What help do you need ?

What errors are you getting ?

Re: need help in using cursors [message #251178 is a reply to message #251166] Thu, 12 July 2007 10:28 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A reminder:
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

What is the goal you're trying to achieve?

Regards
Michel
Previous Topic: how to null value replace' !'
Next Topic: sql vs pl/sql
Goto Forum:
  


Current Time: Sat Dec 10 18:35:33 CST 2016

Total time taken to generate the page: 0.10173 seconds