Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help : PL/SQL Cursor Limitations
phil chang <pxchang0_at_sunspot.wcc.com> wrote in
<5r8b7m$lr6$1_at_news-2.csn.net>...
> I'm coming into this late, without the original posting in front of me,
but I
> believe the following will work in this case.
>
> select Emp_Name
> from Employee
> where
decode(sign(instr(:global.string,ltrim(to_char(Emp_id,'09')))),1,Emp_id,0)
= Emp_id;
>
Thank you, Phil, I enjoy your idea!
It realy work, but why not
where instr(:global.string,ltrim(to_char(Emp_id,'09'))) > 0
?
All the best, Nikolay
Received on Fri Jul 25 1997 - 00:00:00 CDT