about PL/SQL cursor

From: CL <charlie_at_xenacom.co.nz>
Date: Wed, 1 Sep 1999 21:26:53 +1200
Message-ID: <Lg6z3.69$TD3.2681@news.clear.net.nz>

I am going to use a cursor to query some records upon the a cursor parameter.
the parameter is the operator. some thing like this:

cursor cur_test( opr in varchar2, dept in number) is

   select ename
   from emp
   where deptno opr dept;

then I want to call this cursor as

for rcd in cur_test('>', 30) loop

     ....
     null;

end loop;

Please help. Thanks

Qianli Luo Received on Wed Sep 01 1999 - 04:26:53 CDT