字符串括号及括号里的内容过滤

[huanmie_09]

原串示例：(t1)ha(t2)hb
功能：过滤原串中的括号及括号内的字符
过滤后预期结果：hahb

[youshang444]

SELECT regexp_replace('(t1)ha(t2)hb','\(..\)') FROM dual;

[huanmie_09]

[Quote=引用 1 楼 youshang444 的回复:]
SQL code

SELECT regexp_replace('(t1)ha(t2)hb','\(..\)') FROM dual;
[/Quote]
不限于括号内只有两个字符哈。

[huanmie_09]

SQL> SELECT REGEXP_REPLACE('(t1)ha(t2)hb', '(\((.)*\))*(（(.)*）)*( )*/?', '') col
  2    FROM dual;

COL
---
hb

我之前这样处理，达不到想要的效果.

[xiaobn_cn]

select regexp_replace('(t1)ha(t2)hb','[(][^()]+[)]') from dual;

[007-x]

[Quote=引用 4 楼 xiaobn_cn 的回复:]
select regexp_replace('(t1)ha(t2)hb','[(][^()]+[)]') from dual;
[/Quote]
改成*能去掉单纯的"()"
select regexp_replace('(t1)ha(t2)hb()()','[(][^()]*[)]') from dual;

[IT职场成长课]

4、5楼正解

[youshang444]

SELECT regexp_replace('(t1ee)ha(t2)hb()()','\(([[:alnum:]])*\)') FROM dual;