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

Question

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

Answer 1

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

Answer 2

SQL> SELECT REGEXP_REPLACE('(t1)ha(t2)hb', '(\((.)*\))*(（(.)*）)*( )*/?', '') col
  2    FROM dual;COL
---
hb我之前这样处理，达不到想要的效果.

Answer 3

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

Answer 4

改成*能去掉单纯的"()"
select regexp_replace('(t1)ha(t2)hb()()','[(][^()]*[)]') from dual;

Answer 5

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