Oracle-defined Union Array

Oracle defines the Union array -- Created on 2010/04/15 by NAN declare www.2cto.com -- Local variables here I integer; v_kbis kbis % ROWTYPE; TYPE t_table IS TABLE OF kbis % ROWTYPE INDEX BY BINARY_INTEGER; -- Define the Union array (Initialization is not required) v_t_table t_table; begin -- Test statements here v_kbis.k001: = '1'; v_t_table (1): = v_kbis; v_kbis.k001: = '2 '; v_t_table (2): = v_kbis; FOR I IN 1 .. v_t_table.count LOOP dbms_output.put_line (v_t_table (I ). k001); end loop; exception when others then dbms_output.put_line (sqlerrm); end;