- or download this
create type StringTable as table of varchar2(4000);
select A.dummy, B.column_value
from dual A, table(StringTable('one', 'two', 'three')) B;
- or download this
DUMMY COLUMN_VALUE
----- ------------------
X one
X two
X three
- or download this
StringTable('one', 'two', 'three')
- or download this
begin
myproc(?, StringArray(?,?,?));
end;