Oracle REGEXP

dear readers here is sample of using the function REGEXP 

select email from <table-name> 
where REGEXP_LIKE (EMAIL,'^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$')

/

Yasser