By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| NVL(SUBSTR(DT,1,INSTR(DT,REGEXP_SUBSTR(DT,'[[:DIGIT:]]{3}'))+2),DT) | SUBSTR(DT,INSTR(DT,REGEXP_SUBSTR(DT,'[[:DIGIT:]]{3}'))+3) |
|---|---|
| A103 | B |
| 103 | C |
| FX104 | D |
| Location2 | null |
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 |
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | 0 |