Thanks for the question, Mano.
Asked: May 21, 2018 - 6:05 pm UTC
Last updated: May 22, 2018 - 7:25 am UTC
Version: 11g
Viewed 1000+ times
declare type a_arr is table of varchar2(20) index by pls_integer; tb1 a_arr; begin tb1(1) := 'aaaa'; tb1(2) := 'bbbb'; tb1(3) := 'cccc'; end; /
SQL> declare 2 type a_arr is table of varchar2(20) index by pls_integer; 3 tb1 a_arr; 4 begin 5 tb1(1) := 'aaaa'; 6 tb1(2) := 'bbbb'; 7 tb1(3) := 'cccc'; 8 9 tb1(10) := tb1(1); 10 tb1(20) := tb1(2); 11 tb1(30) := tb1(3); 12 tb1.delete(1); 13 tb1.delete(2); 14 tb1.delete(1,3); 15 16 end; 17 / PL/SQL procedure successfully completed.
Mano, May 22, 2018 - 9:21 am UTC
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library