associate array declaration

[GoTerps88]

Is there a way to declare and assign an associative array in one statement? Every example I've seen uses a separate line of code to assign each index a value. In most programming languages, you can declare and assign in one statement like so:

c#
int[,] nums = {{0,1},{0,2}};

Also is there a way to make an associative array global to a particular package?

Thanks...

 

[GoTerps88]

I want to create an associative array that is indexed by varchar2.

For example, an array of reference codes and reference periods for months of the year.

TYPE t_referenceperiods IS TABLE OF VARCHAR2(25)
INDEX BY VARCHAR2(25);
v_referenceperiods t_referenceperiods;
v_referenceperiods('M01') := 'January';

 

[LKBrwnDBA]

Try something like this:

DECLARE
   TYPE t_rp IS TABLE OF VARCHAR2 (25)
      INDEX BY VARCHAR2 (32);
   v_rp   t_rp;
   ix     VARCHAR2 (32);
BEGIN
   v_rp ('First') := 'This is the first.';
   v_rp ('Second') := 'This is the second.';
   ix := v_rp.FIRST;
   FOR x IN 1 .. v_rp.COUNT
   LOOP
      DBMS_OUTPUT.put_line (x || ' = ' || ix || ' - ' || v_rp (ix));
      ix := v_rp.NEXT (ix);
   END LOOP;
END;
/

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Dagon]

To make the associative array global, all you have to do is either declare it in the package spec or at the top of the package body (before any of the procedure or function definitions).