oracle个人笔记

create or replace type aaa is table of varchar2(20);

 CREATE OR REPLACE FUNCTION A_Test(
                orType varchar2
        )RETURN aaa
        is
               a aaa := aaa(); 
	       i number;
        BEGIN
	 for i in 1..8 loop
		a.extend;
		a(a.Count) :='a'||i;
	 end loop;          
         RETURN  a;
        END;