using REGEXP_LIKE and REGEXP_INSTR

SELECT 1

FROM DUAL

WHERE REGEXP_LIKE ('ANAND_1983@LIVE.in', '^ [a-zA-Z0-9+_+.]+@[a-zA-Z0-9]+\.[a-zA-Z]{2,4}$');