Search code examples
oracle-databaseregexp-substr

Oracle SQL regexp_substr to find the numbers in a string

I want use regexp_substr to return the number after the characters from a string value

eg. String Value return 100AUS50 50 100AUS100 100 100AUS500 500
Jan-20 20 Four200 200

Solution

  • You can use the below to get the number 

     select regexp_substr(column,'\d+$') from TABLE;