Default Value Insertion and Integrity Constraint Checking (164)

tsinglee發表於2007-11-08

Integrity constraint checking occurs after the row with a default value is inserted. For
example, a row is inserted into the emp table that does not include a
value for the employee's department number. Because no value is supplied for the
department number, Oracle inserts the deptno column's default value of 20. After
inserting the default value, Oracle checks the FOREIGN KEY integrity constraint
defined on the deptno column.

預設值的插入及完整性約束檢查
1. 當一個包含預設值的行被插入之後將發生完整性約束檢查 .

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981301/,如需轉載,請註明出處,否則將追究法律責任。

相關文章