Column Name of PL/SQL Table-Type Column Name of PL/SQL Table-Type oracle oracle

Column Name of PL/SQL Table-Type


But what is the column name of that one column in the result set?

Pseudocolumn named column_value.

-- nested table schema object typecreate type t_list as table of numberselect column_value  from table(T_List(1,2,3))  COLUMN_VALUE------------           1            2            3 

Note: In this case it's not allowed to use rowid pseudocolumn, simply because in-memory nested table does not have one.


It's column_value, the following should work:

SELECT rowid, p.column_valueFROM TABLE(strings) p;