I have three different procedures which returning result set (by using ref cursor) based on based on give id;
for all the procedure input id is same.
After execution the procedures I am having three different result.
--proc 1o/p
1 r1 r2 r3 r4 r5 r5
--proc 2 o/p
1 t1 t2 t3 t4 t5 t6
--proc 3 o/p
1 g1 g2 g3 g4 g5 g6
I want data like below (id : 1)
1. r1, r4, t2 ,t4, g5, g6
kindly help me on this!!!
Thanks in advance.