Hello.
Could you help me please, wtih the following issue:

As I initializate a nested table at the some time of declaration :

DECLARE
  TYPE table_contacts IS TABLE OF VARCHAR2(1024);
  tab table_contacts := table_contacts('John','George','Merkel');

BEGIN
dbms_output.put_line(tab(1));
dbms_output.put_line(tab(2));
dbms_output.put_line(tab(3));

END;


Isn't not possible to do something similar with the assciative
arrays :


DECLARE
 TYPE assoc_array IS TABLE OF VARCHAR2(30)
 INDEX BY VARCHAR2(30);

 state_array assoc_array;
BEGIN
  state_array('Alaska') := 'Juneau';
  state_array('California') := 'Sacramento';
  state_array('Oregon') := 'Salem';
  state_array('Washington') := 'Olympia';

  dbms_output.put_line(state_array('Alaska'));
  dbms_output.put_line(state_array('California'));
  dbms_output.put_line(state_array('Oregon'));
  dbms_output.put_line(state_array('Alaska'));
END;


It's possible initilizate this array with this values in the
declaration section ? Someting similar to the first example?




Regards,
Paulito Santana

-- 
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

Reply via email to