By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
---|---|---|---|
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 |
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | 0 |
2 rows affected
A | REGEXP_SUBSTR(A,'[^-]+',1,2) |
---|---|
xx-target-xx | target |
xx-target | target |
A | VALUE |
---|---|
xx-target-xx | target |
xx-target | target |