ALTER TABLE customers ADD CONSTRAINT cust_email_addr CHECK(REGEXP_LIKE(cust_email,'@'))NOVALIDATE ;SELECT * FROM names WHERE regexp_like (name , 'z') ; -- Oracle REGEXP_LIKE example would --retrieve all of the names that contain the letter ‘z’. NAME ------------------------- Lorentz Gietz