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!

extract ID's from a list of comma separated values

Roger252 days ago — edited 2 days ago

Hello,

Don't know if it is possible using regular expressions, but if I have a string like:

'54 - testOne,18 - testXY,19 - testXZ'

How can I extract only the ID's marked? as then I want to use them in a SQL statement like.. table.column in (54,18,19)

ID's are only present before the “ - ”

Thanks!

This post has been answered by Gerrit van der Linden on Mar 11 2026

Jump to Answer

Added 2 days ago

2 comments

42 views