how to return a table in pl sql functions code example
Example 1: plsql function that return a table
create or replace type t_record as object (
i number,
n varchar2(30)
);
/
Example 2: plsql function that return a table
create or replace type t_table as table of t_record;
/