No not really.Hope I am much clearer now.![]()
If you just want to update a column,
then use the update with the replace function.
If you want to generate new rows,Code:update SUSERIDTABLE set key=replace(key, 'this', 'that') where username like '%theother%';
then do an insert from a select.
Code:insert into SUSERIDTABLE ( username ) select 'test'||rownum||'.IsUser' from user_objects WHERE rownum < 101;




Reply With Quote