By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REGEXP_SUBSTR('CH99//4//SUB//58691516//JKC12/12/22','//(.*?)//',1,1,NULL,1) |
|---|
| 4 |
| REGEXP_SUBSTR('CH99//4//SUB//58691516//JKC12/12/22','//(.*?)//',1,1,NULL,1) |
|---|
| 4 |