求oracle正则表达式一例

[muou2008]

数据：dad(disc_id = 90910 and disc_item_id in (91793,92375)) and (disc_id = 91648 and disc
_item_id in (92625,92626)) or (disc_id = 50001610 and disc_item_id =50002164) or
(disc_id = 50005959 and disc_item_id =50003118)add

最后需要的结果如下：
(disc_id = 90910 and disc_item_id in (91793,92375))(disc_id = 91648 and disc
_item_id in (92625,92626))(disc_id = 50001610 and disc_item_id =50002164)(disc_id = 50005959 and disc_item_id =50003118)add

说明：需要找出数据中的所有第一级括号里面的内容。

[虫洞]

正则啊
软肋

[碧水幽幽泉]

路过，帮顶了！

[muou2008]

继续等待...

[muou2008]

等待高手出场!!

[xman_78tom]

declare
 s varchar2(300);
begin
 s:='dad(disc_id = 90910 and disc_item_id in (91793,92375)) and
    (disc_id = 91648 and disc_item_id in (92625,92626)) or
    (disc_id = 50001610 and disc_item_id =50002164) or
    (disc_id = 50005959 and disc_item_id =50003118)add';

 select regexp_replace(s,'[^\(\)]*(\(.*\))[^\(\)]*','\1')||regexp_substr(s,'[^\(\)]*$') into s from dual;
 dbms_output.put_line(s);
end;
/

[liang8976]

学习一下。。。。。

[muou2008]

谢谢 楼上的！

[多壮志]

select regexp_replace(x,'(^([A-Z]{1,}\()|(\)[A-Z]{1,})$)','',1,0,'i') from dual

[WXHDSWH]

mark and wait