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;