Q. Write PL/SQL Program For Limit Method Of PL/SQL Table.
Output:
DECLARE
TYPE array_type IS ARRAY(100) OF NUMBER ;
my_array array_type:=array_type(1,2,3,4,5,6,7,8,9,10);
BEGIN
DBMS_OUTPUT.PUT_LINE('Maximum Array Size Is '||my_array.LIMIT);
End;
/
Maximum Array Size Is 100
PL/SQL procedure successfully completed.
Compatibility (Tested on):
Oracle Database 10g Express Edition Release 10.2.0.1.0 – Product
