Oracle Developer Question:
Download Job Interview Questions and Answers PDF
What are the Limitations of a CHECK Constraint?
Answer:
The condition must be a Boolean expression evaluated using the values in the row being inserted or updated and can't contain subqueries, sequence, the SYSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
Download Oracle Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is the maximum number of CHECK constraints that can be defined on a column? | What is self-referential integrity constraint? |