Delete based on boolean record found

I also got the reply from friend,

create or replace function isnumber (in_value varchar2) return number
as
chk_number number;
begin
chk_number := in_value;
return 1;
exception
when others then
return 0; -- is this is character
end;

delete ...
from ..
where (seq,0) = (select seq,isnumber(in_value) from ..);


Enjoy!!

why do have to create PL/SQl when you can do it in SQL statement ?:confused: :confused: