Help for this page

Select Code to Download


  1. 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;
    
  2. or download this
    DUMMY COLUMN_VALUE
    ----- ------------------
    X     one
    X     two
    X     three
    
  3. or download this
    StringTable('one', 'two', 'three')
    
  4. or download this
    begin
       myproc(?, StringArray(?,?,?));
    end;