select * from GetEmployees() where id > 2;

Eg: SELECT empname sal
FROM employee_table
WHERE sal<MAX(sal) AND sal>MIN(sal);

Hope the above statement executes.

create or replace function f1 return sys_refcursor as

r1 sys_refcursor;

begin open r1 for select * from emp;

return(r1);

end;

call the function as: select f1 from dual;

Thanks & Regards

RAJIV GUPTA (ORACLE CONSULTANT)

YOGIK TECHNOLOGIES PVT LTD.