PL/SQL (MOSC)

MOSC Banner

merging two arrays

edited May 17, 2013 6:18AM in PL/SQL (MOSC) 3 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center