Re: about PL/SQL cursor

CL wrote:

> 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

You need to learn how to write dynamic pl/sql.That will solve your problem. Received on Wed Sep 01 1999 - 06:45:30 CDT