Extract data from rows using SQL

[MariuzM]

Hi everyone first time here hope someone could help me, I need a SEL statment from speciefied column to only show speciefied text with number, example below: 

ID (column name)
=================
ID1
ID2
ID3
IDabc
abcID
abcID123

The output should be only ID part that also has a number next to it, result i should get is:

ID1
ID2
ID3
ID123

[dnoeth · Accepted solution]

This Regular Expression returns 'ID' followed by any number of digits:

RegExp_Substr(ID, 'ID\d')

[MariuzM]

Thank you that worked i've only added + after d to get leading numbers

[dnoeth]

Yes, of course, I forgot the '+'.