Limitations of Check Constraint

• A Check constraint cannot be defined on a view
• The Check constraint defined on a table must refer only the columns in that table. It cannot refers to columns in other table
• A Check constraint cannot include in a SUB QUERY
• The Condition must be a Boolean expression evaluated using the values in the rows being inserted or updated
• Cannot contain Sub queries, Sequence, SYSDATE, UID, USER or USERENV Sql functions, Also Pesudo columns LEVEL and ROWNUM