SQL

plsql function that return a table

create or replace type t_record as object (
  i number,
  n varchar2(30)
);
/

plsql function that return a table

create or replace type t_table as table of t_record;
/