I am looking for email-id validation
BEGIN FOR rec IN (
SELECT 'abc@test.com' as email FROM dual union all
SELECT 'abc_1@test.com' as email FROM dual union all
SELECT '_abc1@test.com' as email FROM dual union all
SELECT 'abc#1@test.com' as email FROM dual union all
SELECT 'abc 12@test.com' as email FROM dual union all
SELECT 'abc@test.a.com' as email FROM dual union all
SELECT 'abc@test.a.com,def@test.com' as email FROM dual union all
SELECT 'abc-12@test-1.a.com' as email FROM dual union all
SELECT 'abc-12@test-1.a.co m' as email FROM dual union all
SELECT 'abc-12@test-1.a.com ' as email FROM dual union all
SELECT 'abc@test-1.com' as email FROM dual )
LOOP
IF REGEXP_LIKE(rec.email, '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$')
THEN null;
ELSE DBMS_OUTPUT.PUT_LINE(rec.email||' - The email address is invalid ');
END IF;
END LOOP;
END;