By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REGEXP_SUBSTR('ABC_BAS','(.*)([_]|$)?',1,1,NULL,1) |
|---|
| ABC_BAS |
| REGEXP_SUBSTR('ABC','(.*)([_]|$)?',1,1,NULL,1) |
|---|
| ABC |
| REGEXP_SUBSTR('ABC_BAS','(.*)([_]|$)?',1,1,NULL,1) |
|---|
| ABC_BAS |
| REGEXP_SUBSTR('ABC','(.*)([_]|$)?',1,1,NULL,1) |
|---|
| ABC |