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.