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!

How can I do this in xquery

ronald_2017Oct 26 2023

Hello All,

In Oracle 19c, how can I do the following in xquery? I want to get all characters until numeric values.

I need to equivalent of the following in xquery.

select regexp_substr('ABC12', '[a-zA-Z]+', 1) from dual;

Thanks in advance

This post has been answered by user-cvrwb on Oct 26 2023
Jump to Answer
Comments
Post Details
Added on Oct 26 2023
4 comments
168 views