varios datos en retorno
CREATE TYPE empno_tbl
IS TABLE OF NUMBER;
/
CREATE OR REPLACE FUNCTION get_empnos
RETURN empno_tbl
IS
l_empnos empno_tbl;
BEGIN
SELECT empno
BULK COLLECT INTO l_empnos
FROM emp;
RETURN l_empnos;
END;
/
select * from table(get_empnos() ) ;
/
select 2 from dual where (7369,7499) in (select * from table(get_empnos()));