--剔除
UPDATE TEST1 T SET T.A= REPLACE(T.A,'2','AAAA')
SELECT * FROM TEST1
--追加
UPDATE TEST1 SET A = A ||',1' WHERE A=2;
commit;SELECT * FROM TEST1;
--剔除
UPDATE TEST1 T SET T.A= REPLACE(T.A,'2','AAAA')
SELECT * FROM TEST1
--追加
UPDATE TEST1 SET A = A ||',1' WHERE A=2;
commit;