oracle函数返回表

CREATE OR REPLACE TYPE obj_date IS OBJECT (
    date_val DATE
);
CREATE OR REPLACE TYPE nt_date IS TABLE OF obj_date;

create or replace function test_pipelined(
        p_num  in number
)
  return nt_date 
  pipelined
  is
  begin
  for tab1 in (
select sysdate + level lv from dual connect by level < p_num + 1
  ) loop
  pipe row (obj_date(tab1.lv));
  end loop;

  return;
end test_pipelined;


select * from table(test_pipelined(10));