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!

Remove parenthesis from string

Sid_ Z.Jul 28 2016 — edited Jul 28 2016

Hi,

I have string like this 'abc(21), xyz(0.6788), pqr(-23)'.

And I want the output like - 'abc ,xyz,pqr'.

I want to remove the parenthesis and the number inside the bracket, be it positive or negative or decimal.

Will REGEXP_REPLACE is useful?

Regards,

Sid

This post has been answered by Manik on Jul 28 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2016

Added on Jul 28 2016

5 comments

1,451 views