I have to generate something like this ,i have the year and magazine details in one cursor
and customer/magazine details in another cursor,now if i find a match then i have store 'Y' in
a variable if no match found i have to put 'X'.And i have to send it out in ref cursor or array
since the expecting front end is java.These 'x' and 'y' or not in database based on match i have put
it and send it.
I did send the magazine cursor out first to display the heading.But whatever is underneath
even though i loop through the magazine and customer/magazine cursor i do not know how to
set 'x' and 'y' and sent it back.
year 1999 year 2000
mag1 mag2 mag3 mag4 mag5
customer1 X Y Y X x customer2 Y Y Y Y y customer3 X X Y X y
and customer/magazine details in another cursor,now if i find a match then i have store 'Y' in
a variable if no match found i have to put 'X'.And i have to send it out in ref cursor or array
since the expecting front end is java.These 'x' and 'y' or not in database based on match i have put
it and send it.
I did send the magazine cursor out first to display the heading.But whatever is underneath
even though i loop through the magazine and customer/magazine cursor i do not know how to
set 'x' and 'y' and sent it back.
year 1999 year 2000
mag1 mag2 mag3 mag4 mag5
customer1 X Y Y X x customer2 Y Y Y Y y customer3 X X Y X y