RSA Scripts

Check phone syntax

Check phone syntax.

  1. Oracle
  2. Regexp
  3. Intermediate
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

SELECT MISPAR_TELEFONE,
       regexp_substr(MISPAR_TELEFONE,'[[:digit:]]+'),
       regexp_substr(MISPAR_TELEFONE,'[[:digit:]]+$') 
  FROM table_name
 WHERE REGEXP_LIKE(MISPAR_TELEFONE,'?0?[2347890]{1}(\-)?[^0\D]{1}\d{6}$')
 ORDER BY 1