OracleÊý×éÈëÃÅ

OracleÊý×éÒ»°ã¿ÉÒÔ·ÖΪ¹Ì¶¨Êý×éºÍ¿É±äÊý×é
¹Ì¶¨Êý×é
Sql´úÂë
   declare 
   type v_ar is varray(10) of varchar2(30); 
   my_ar v_ar:=v_ar('g','m','d','¹¨','˧'); 
   begin 
          for i in 1..my_ar.count 
          loop 
              dbms_output.put_line(my_ar(i)); 
          end loop; 
    end; 
declare
type v_ar is varray(10) of varchar2(30);
my_ar v_ar:=v_ar('g','m','d','¹¨','˧');
begin
      for i in 1..my_ar.count
      loop
          dbms_output.put_line(my_ar(i));
      end loop;
end;
¿É±äÊý×é
һάÊý×é
Sql´úÂë
    declare 
    type v_table is table of varchar2(30) index by binary_integer; 
    --ÀàÐÍ¿ÉÒÔÊÇÇ°ÃæµÄÀàÐͶ¨Ò壬index by binary_integer×Ó¾ä´ú±íÒÔ·ûºÅÕûÊýΪË÷Òý£¬ 
    --ÕâÑù·ÃÎʱíÀàÐͱäÁ¿ÖеÄÊý¾Ý·½·¨¾ÍÊÇ“±í±äÁ¿Ãû(Ë÷Òý·ûºÅÕûÊý)”¡£ 
    my_table v_table; 
    begin 
          for i in 1..20 
          loop 
              my_table(i):=i; 
             dbms_output.put_line(my_table(i)); 
         end loop; 
   end; 
declare
type v_table is table of varchar2(30) index by binary_integer;
--ÀàÐÍ¿ÉÒÔÊÇÇ°ÃæµÄÀàÐͶ¨Ò壬index by binary_integer×Ó¾ä´ú±íÒÔ·ûºÅÕûÊýΪË÷Òý£¬
--