Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Regexp to extract text inside braces ?

Test2Sep 20 2013 — edited Sep 26 2013

Hello,

I need to extract a text inside braces. I used this :

select regexp_substr ( 'Churchill Executive, in Business Bay ( Commercial )' , '\(([^)]*)\)' ) from dual ;

But, I got :

( Commercial ) .

I need to get only:

Commercial

Any help please.

Regards,

I use Oracle 11.2.0.3
This post has been answered by Frank Kulash on Sep 20 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2013
Added on Sep 20 2013
5 comments
5,818 views