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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
