Array in oracle
DECLARE type namesarray IS VARRAY(5) OF VARCHAR2(10); type grades IS VARRAY(5) OF INTEGER; names namesarray; marks grades; total integer; BEGIN names := namesarray(‘Kavita’, ‘Pritam’, ‘Ayan’, ‘Rishav’, ‘Aziz’); marks:= grades(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) || ‘ … Read more