Unfortunately, I'm stuck accessing an Oracle 9 database so don't have the luxury of using regex. The regex that I would expect to use is '([0-9]+)'.
How can I SELECT the first integer number from an alphanumeric column in Oracle 9? Commas decimal points and spaces should break a number.
'Port #123' should return '123'.
'123 456' should return '123'.
'6 on 4 should return '6'.
'Use 3.1415 for pi' should return '3'.
'Count 1,2,3' should return '1'