SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Substr and Instr

GUS CRIGHTONOct 8 2025

I have a string that I need to split but this is driving me crazy

P255721Q1D25092025

Needs to be split into 3 fields

1 after the P but before Q (can be different lengths)

2 after Q but before D (can be different lengths)

3 after D (always the same length. It is a date)

Any help appreciated

Reagrds

Gus

This post has been answered by F.Eicken on Oct 8 2025

Jump to Answer

Added on Oct 8 2025

4 comments

130 views