Re: IN comparison using PL/SQL?

Probably not what you are looking for, but you can populate a temp table with the "in list" entries, and access it with a subselect.... where first_name in (select first_name from temp_table)

• steve

> Within a Stored procedure:
>
> Can someone please tell me how or if you can use a string variable in
> an IN comparison
> of a Where clause? The following statement will work:
>
> Select * from Employee where First_name in ('Tony','Mark','Steve');
>
> But when the contents are passes as a variable, it will not work, as
> follows:
>
> TempStr := 'Tony','Mark','Steve'
> Select * from Employee where First_name in (TempStr);
>
> If anyone has a work around, I would appreciate the help.
>
> Thanks, Tony
Received on Sun Dec 13 1998 - 18:27:33 CET