Может ли функция вернуть n столбцов

function func(url in string) return sys_refcursor 
is
v_cur sys_refcursor; 
begin 
open v_cur for select 1 a,2 b,3 c from dual; 
return v_cur; 
end func;

select func('test') from dual

create or replace type t_emp as object (
    empno number(4)
  , ename varchar2(10)
)
/
create or replace function get_emp (p_empno number) return t_emp as
  v_emp t_emp := t_emp(null, null);
begin
  select empno, ename
  into v_emp.empno, v_emp.ename
  from scott.emp
  where empno = p_empno;
  return v_emp;
end;
/
select e.x.empno, e.x.ename from (select get_emp(7369) x from dual) e;

select * from table (pkg_test.get_emp);