Tag Archives: pl-sql

Vérifier la validité d’une adresse email en PL-SQL

Usage des expressions régulières, quand tu nous tient 🙂 create or replace FUNCTION isEmail(Email IN VARCHAR2 ) RETURN boolean AS email_dummy VARCHAR2(60); BEGIN SELECT regexp_substr(Email, ‘[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}’) INTO email_dummy FROM dual;

Posted in SQL | Tagged , , , | Leave a comment