数据准备
CREATE TABLE test22 ( a VARCHAR2(100));
INSERT INTO test22 VALUES('aa+bb+ds+aa++++');
INSERT INTO test22 VALUES('aa+bb+++++');
INSERT INTO test22 VALUES('aa++++++');
COMMIT;
原始数据:
sql方案:
SELECT regexp_replace(s.a,'[+]{2,}','') FROM test22 s;
结果: