2、替换掉[]保留"内容".
Select REGEXP_REPLACE('[TEST]', '(\[)(\w*)(\])', '') from dual; ---这个oK
Select REGEXP_REPLACE('[TEST *< ]', '(\[)(\w*)(\])', '') from dual;---特殊字符就不行
Select REGEXP_REPLACE('[AND PP.INTEGRAL>=NVL(#CON_PARAM#,0)]', '(\[)(\w*)(\])', '') from dual;
急,请高手指教