merging two arrays
Hi,
I have requirement like this
i am getting a table type parameter from java like below
1 1001,5 stores in as a single value
2 1002,6
3 1003,5
4 1004,6
and i need to pick some values from a table and is of like below
1 1001
2 2002
3 2003
table may have many rows than count of array and vice verse(array may have more count than table)
now i need compare two table types and need to merge with value||','||0 for the indexes which are coming from table and are not present in param nested table
expecting out put is
1 1001,5 stores in as a single value
2 1002,6
3 1003,5
4 1004,6
5 2002,0
6 2003,0
any body have some hints
0