Define and output an array under Oracle

Analysis:

The first thing to do is to have an array type before you can define an array variable, so write PL/SQL as follows:

Declare  --defines an array type  a_type is table of number;  A a_type: = A_type (); Begin  A.extend (3);  A (1): = 1;  A (2): = 2;  A (3): = 3;  For cou in 1.. A.count Loop    Dbms_output.put_line (A (cou));  End Loop;end;

Other methods and properties:

First  --  The index of the second element - -  The last element subscript Count-- The number of array elements -- -  subscript n the previous element  subscript Next-subscript n after an element subscript -  add n array elements, Add an array element without parameters Delete--  Delete the element labeled N in the array, delete the entire array element without parameters

　　

Define and output an array under Oracle