Conditions mentioned in the CHECK constraint must be a boolean exp,they cannot be subqueries or sequences n cannot include the SYSDATE,UID,USER, USERNV SQLfunctions
