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!

Using regular expression substr to return the string

chvsnarayanaMar 6 2024

Hi All,

I have requirement to show only some part of the string from the below column value.
Could you please help me on this.

We are using Oracle 19C.

Column Value
"DC AC Legal Closing Confirmation has replied to the confirmation that conditions have been met."
"DC AIC Legal Closing Confirmation has replied to the confirmation that conditions have been met."

Expected return value
"DC AC Legal Closing Confirmation"
"DC AIC Legal Closing Confirmation"

Thanks in advance.

This post has been answered by Frank Kulash on Mar 6 2024
Jump to Answer
Comments
Post Details
Added on Mar 6 2024
4 comments
306 views