Use the Oracle10g Collection API FIRST and LAST methods against a collection. : Table of number « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Table of number

Use the Oracle10g Collection API FIRST and LAST methods against a collection.

   
SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL>
SQL> DECLARE
  2
  3    
  4    TYPE number_table IS TABLE OF INTEGER INDEX BY VARCHAR2(9 CHAR);
  5
  6    
  7    number_list NUMBER_TABLE;
  8
  9  BEGIN
 10
 11    
 12    number_list('One') := 1;
 13    number_list('Two') := 2;
 14    number_list('Nine') := 9;
 15
 16    
 17    DBMS_OUTPUT.PUT_LINE('FIRST Index :'||number_list.FIRST);
 18    DBMS_OUTPUT.PUT_LINE('NEXT  Index :'||number_list.NEXT(number_list.FIRST));
 19
 20    
 21    DBMS_OUTPUT.PUT_LINE(CHR(10)||'LAST  Index :'||number_list.LAST);
 22    DBMS_OUTPUT.PUT_LINE(' PRIOR Index :'||number_list.PRIOR(number_list.LAST));
 23
 24  END;
 25  /
FIRST Index :Nine
NEXT  Index :One

LAST  Index :Two
PRIOR Index :One

PL/SQL procedure successfully completed.








Related examples in the same category

1.use virtual table in PL/SQL block
2.TYPE NumbersTab IS TABLE OF NUMBER.
3.Legal and illegal table assignments.
4.Number Table by BINARY_INTEGER
5.Declare an index-by table variable to hold the employee records that we read in
6.Clear the salaries table by assigning the empty version to it
7.assignments to nested table elements, and the ORA-6533 error.
8.Use nested table constructors.
9.NULL key value in an index-by table
10.Try to insert elements 3 through 5
11.Use the Oracle10g Collection API COUNT method against an element.
12.Use the Oracle10g Collection API DELETE method against a set of elements.
13.Use the Oracle10g Collection API EXISTS method against an element.
14.Use the Oracle10g Collection API EXTEND method against an element.
15.A nested table of a scalar variable:
16.Associate array: varchar2 to number map
17.Delete a elements from 2, 3 and 4.
18.Delete element 2.
19.number_list.EXTEND(2): Add two null value members at the end of the list.
20.number_list.EXTEND(3,4): Add three members at the end of the list and copy the contents of item 4
21.EXISTS method
22.Use variable.Last to get the last element
23.Extend space in number list.
24.FIRST method returns the lowest subscript value used in a collection
25.Table of number index by varchar2