OraFAQ Forum: Forms » how to use Cursor for loop ?

Home » Developer & Programmer » Forms » how to use Cursor for loop ? (oracle forms 10g,11.1.7.0)

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

how to use Cursor for loop ? [message #629811]

Tue, 16 December 2014 04:29

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

A B
-- --
1 (1+2+3+4)-1=9
2 (2+3+4)-2=7
3 (3+4)-3=4
4 (4-4)=0


Per my example, I should sum(A) that > current value
to obtain value of B
IF A=1, then only (2,3,4) > 1, so I will SUM(2,3,4) to get 9
IF A=2 then only (3,4) > 2, so I will SUM(3,4) to get 7

Using cursor for Loop , so how to implement this in Oracle forms

Thanks in advanced,I don't want to hard code of A values(from in the above code) If a=1 then..bcz we don't know what values are in the A column's

[Updated on: Tue, 16 December 2014 04:31]

Report message to a moderator