Parsing input string in SP

[sudhakard]

Hi,
I want to delete a multiple records from stored procedure in a single execution using INPUT parameter.
For example, i want to delete multiple records from EMP tables. The input parameter for this is Empnos(7348,7399,7468). Here i want to delete Employee numbers 7348,7399,7468 in a single execution
Can any one give me suggestion for this. Thanks in advance

Regards,
Sudhakar

 

[lewisp]

DELETE emp
WHERE empno IN (7348,7399,7468);

 

[lewisp]

Does anyone know how to delete your own post in Tek-Tips when you realise you've been stupid?

 

[sem]

execute immediate 'delete from emp where id in ('||emp_list||')'

Regards, Dima

 

[BJCooperIT]

"Does anyone know how to delete your own post in Tek-Tips when you realise you've been stupid?"

Wouldn't that be nice? I suppose you could red flag your post and hope they delete it quickly.

select * from Life where Brain is not null

Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
^{When posting code, please use TGML for readability. Thanks!}