oracle返回自定义类型,Oracle 方法返回自定义表类型的例子

create or replace type t_test as object(

id integer,

rq date,

mc varchar2(60)

);

create or replace type t_test_table as table of t_test;

create or replace function f_test_array(n in number default null) return t_test_table

as

v_test t_test_table := t_test_table();

begin

for i in 1 .. nvl(n,100) loop

v_test.extend();

v_test(v_test.count) := t_test(i,sysdate,'mc'||i);

end loop;

return v_test;

end f_test_array;

/

看结果执行

select * from table(f_test_array(10));

或者

select * from the(select f_test_array(10) from dual);