Combining 2 VARRAY's from different records in 1 table in 1 query and unnesting the result :-)

Hi,

I'm having a table with a VARRAY as item. Now must combine two of these in one query:

Record 1: (1 2 3 4 5) ( = a VARRAY)
Record 2: (a b c d e)

Now I want to show on the output (of sqlplus without intermediate PL/SQL code because of performance):
1 a
2 b
3 c
4 d
5 e

I can show the first and second column seperate by an "unnested" query, but combining??? Do not know how...

Anyone?

Gezzy Received on Thu Oct 17 2002 - 14:09:40 CDT