No quick solution... and I do believe what you read in the newsgroups is correct.
I would create a function that would accept your list, so change your update to something like this:
Code:
update table
set state = 'N'
where find_me(pValues, myValue)
where...
Code:
function find_me (values_p varchar2, rowid_p varchar2 )
return boolean
is
begin
return( values_p like ( '%' || rowid_p || '%') );
end;
That's basically it... you would probably want to do more to ensure that sub string matches don't return true, for instance, not returning a match if pValues = 'ABC,DEF...' and myValue = 'A'.
Hope this sends you in the right direction.
JoeB
dBforums
>
Oracle 8.1.7 SP and IN operator
12-27-03, 05:14
Linear Mode
