assoc_array.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 39 行

DECLARE
   TYPE population_type IS TABLE OF NUMBER INDEX BY VARCHAR2(64);
	  
   country_population population_type;
   continent_population population_type;
   
   howmany NUMBER;
   limit VARCHAR2(64);
BEGIN
   country_population('Greenland') := 100000;
   country_population('Iceland') := 750000;
     
   continent_population('Australia') := 30000000;
   
   continent_population('Antarctica') := 1000; 
	  
   continent_population('Antarctica') := 1001; 

   howmany := country_population.COUNT;
   DBMS_OUTPUT.PUT_LINE ('COUNT = ' || howmany);
 
   limit := continent_population.FIRST; 
   DBMS_OUTPUT.PUT_LINE ('FIRST row = ' || limit);
   DBMS_OUTPUT.PUT_LINE ('FIRST value = ' || continent_population(limit));
   
   limit := continent_population.LAST; 
   DBMS_OUTPUT.PUT_LINE ('LAST row = ' || limit);
   DBMS_OUTPUT.PUT_LINE ('LAST value = ' || continent_population(limit));
END;
/


/*======================================================================
| Supplement to the third edition of Oracle PL/SQL Programming by Steven
| Feuerstein with Bill Pribyl, Copyright (c) 1997-2002 O'Reilly &
| Associates, Inc. To submit corrections or find more code samples visit
| http://www.oreilly.com/catalog/oraclep3/
*/