Search code examples
regexoracleoracle-sqldeveloper

Regular Expression patterns in Oracle SQL developer: include numbers


I am trying to find the pattern using oracle sql developer. Include numbers that are "x0000"," 0000",".0000"

AND REGEXP_INSTR(string=>FTP.TEXT, pattern=>'[x]\d\d\d\d\s', match_parameter=>'i')

Solution

  • Use

    where REGEXP_LIKE(str,'[x.[:space:]]\d{4}','i')
    

    The [x.[:space:]]\d{4} expression matches x, . or any whitespace, then any four digit characters.