Picking up Number From a String Using Regular Expressions - Oracle Sql

 In Oracle SQL, you can use regular expressions to extract exactly the 5-digit number from a string like "Multiple emp ID in this text 1.) 7369 2.> 7521 3.] 7782 4.} 7934".

Here’s a one-liner using REGEXP_SUBSTR: