Hello,
i´m trying to use index-by table in Select clause in a Select statement. Here is example.
TYPE t_col IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
v_col t_col;
--fill some data in the v_col table
SELECT t.column, v_col(t.column)
FROM table t
WHERE ......;
and i got the PLS-00201: identifier 't.column' must be declared. Why oracle doesn´t alow this construction? Is there any way to do something like this? I am only able to use
the index-by table in select cllause, if there is a variable as index of the index-by table instead of the table column.