Hi,
I have data like
col1, col2
10023, 234
13453, 342
12345, 542
First thing, i wanted to load these contents into a collection ( PL/SQL table ) where col1 should act as a key and col2 as value.
col1 cannot be a plain integer in a sequence from 1 to .. Col1 has different integers which are all distinct but not in sequence. I want this column to act as key in pl/sql table or nested table or any collection.
Once i load the data into collection , i wanted to join another table colx with col1 of collection returning, col2 of collection.
Can i do this in PL/SQL? How can load my own numbers as keys into pl/sql table..