oracle table fuction

oracle table fuction

1. object

create or replace type type_object as object

(

aaa varchar2(10),

bbb varchar2(10),

ccc varchar2(10)

)

2. table 

create or replace type type_table as table of type_object

3. function

CREATE OR REPLACE FUNCTION fn_type_test

(

    ps_no1 number,

    ps_no2 number

    

)

    return type_table

    

    is 

    

    v_table type_table := type_table();

    

BEGIN

     for i in ps_no1..ps_no2 

     loop

     

     v_table.extend;

     v_table(i) := type_object(i,i,i);

     

     end loop;

     return v_table;

end;

결과

select * from table(fn_type_test(1,3));

aaa   bbb   ccc  

1 1 1

2 2 2

3 3 3