PLSQL collection 示例 之 Nested Tables

A nested table is like a one-dimensional array.An array has a declared number of elements, but a nested table does not. The size of a nested table can increase dynamically.

删数据，其他element的下标不变

DECLARE
TYPE name_table IS TABLE OF VARCHAR2(10);
TYPE score_table IS TABLE OF INTEGER;

names name_table;
scores score_table;
total integer;
BEGIN
names := name_table(‘Kavita’, ‘Pritam’, ‘Ayan’, ‘Rishav’, ‘Aziz’);
scores:= score_table(98, 97, 78, 87, 92);
total := names.count;
dbms_output.put_line(‘Total ‘|| total || ’ Students’);
FOR i IN 1 .. total LOOP
dbms_output.put_line(‘Student:’||names(i)||’, Scores:’ || scores(i));
end loop;
END;