As shown, and I want to take D D behind the Numbers, other all don't, is there any way I can do it, how do you write?

CodePudding user response:

Select substr (regexp_substr (' asD12353vvv35fhfgh43g ', 'D \ D +), 2) from dual;

CodePudding user response:

There is only one D field?

CodePudding user response:

The building Lord, the following SQL can achieve your demand

 
The select regexp_substr (field name, 'D \ D +) from the name of the table;