IN comparison using PL/SQL?
From: Tony <app1axa_at_air.ups.com>
Date: Mon, 7 Dec 1998 13:24:40 -0500
Message-ID: <74h6o0$elo_at_agbinet.air.ups.com>
Within a Stored procedure:
Date: Mon, 7 Dec 1998 13:24:40 -0500
Message-ID: <74h6o0$elo_at_agbinet.air.ups.com>
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 Mon Dec 07 1998 - 19:24:40 CET