Is there an equivalent to the ROWNUM pseudocolumn for a nested table such that something like this...
WITH driver_data AS
(SELECT 1 AS id, sys.dbms_debug_vc2coll('a','b','c') AS val FROM dual
UNION ALL
SELECT 2 AS id, sys.dbms_debug_vc2coll('x','y','z') AS val FROM dual)
--
--
SELECT t1.id,
--t2.rownum as pos,
t2.column_value AS val
FROM driver_data t1,
TABLE(t1.val) t2 ;
ID VAL
1 a
1 b
1 c
2 x
2 y
2 z
...would return something like this...
ID VAL POS
1 a 1
1 b 2
1 c 3
2 x 1
2 y 2
2 z 3