函数返回表类型

create type wiler_obj as object (table_output varchar2(200));

create type wiler_table as table of wiler_obj;

create or replace function wiler_return_table
return wiler_table
as
  v_table wiler_table:=wiler_table();
begin
  select wiler_obj(object_name) bulk collect into v_table from all_objects where rownum<10;
  return v_table;
end;
/

show err

select * from table(wiler_return_table);