clear screen 

set serveroutput on size unlimited 

select banner from v$version 

create or replace type Names_NT as table of varchar2(32) 

show err 

create or replace package McDodd as 
  function Daughters return Names_NT pipelined; 
  function AllDaughters return Names_NT pipelined; 
end; 

show err 

create or replace package body McDodd as 
  function Daughters return Names_NT pipelined  
  is 
    l_row NedMcDodd.Firstname%type; 
  begin 
    l_row := 'Hooly'; 
    pipe row(l_row); 
    l_row := 'Holy'; 
    pipe row(l_row); 
    return; 
  end; 
  function AllDaughters return Names_NT pipelined  
  is 
  begin 
    for l_row in (select n.firstname from NedMcDodd n where n.type = 18) loop 
      pipe row(l_row.firstname); 
    end loop; 
    return; 
  end; 
end; 

show err 

select * 
  from table(McDodd.Daughters) 

select * 
  from table(McDodd.AllDaughters)