Skip to Main Content

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!

Oracle Regxp Replace

aetlDec 19 2020 — edited Dec 19 2020

Hello Everyone ,

in my clob column i want to replace expressions like these :
{"$date":"2020-12-17T22:21:37.207Z"} with--> "2020-12-17T22:21:37.207Z"
{"$date":"2020-12-19T23:22:34.104Z"} --> "2020-12-19T23:22:34.104Z"
How can i do that ?

Regards

This post has been answered by Frank Kulash on Dec 19 2020
Jump to Answer
Comments
Post Details
Added on Dec 19 2020
3 comments
229 views