oracle的完整性约束（Integrity constraints for Oracle）.docVIP

oracle的完整性约束（Integrity constraints for Oracle） Integrity constraints for Oracle Integrity constraints are used to enhance data integrity, and Oracle provides 5 integrity constraints: Check NOT NULL Unique Primary Foreign key Integrity constraints are a rule that does not occupy any database space. Integrity constraints exist in the data dictionary, which is used during the execution of SQL or PL/SQL. The user can specify whether the constraint is enabled or disabled, and when the constraint is enabled, he increases the integrity of the data; otherwise, otherwise, the constraint remains in the data dictionary. Disable constraints, using the ALTER statement ALTER, TABLE, table_name, DISABLE, CONSTRAINT, constraint_name; or ALTER, TABLE, policies, DISABLE, CONSTRAINT, chk_gender If you want to restart the constraint: ALTER TABLE policiesENABLECONSTRAINT chk_gender Delete constraint ALTER TABLE table_nameDROPCONSTRAINT constraint_name or ALTER TABLEpolicies DROPCONSTRAINT chk_gender; Check constraint On the data column, the Check constraint requires a special Boolean condition, or sets the data column to TRUE, and at least one data column has a value of NULL, and the Check constraint is a simple business rule for increasing the data content in the table. Users use Check constraints to ensure consistency of data rules. Check constraints can involve other data columns whose rows belong to the Check constraint, but cannot refer to other rows or other tables, or call functions SYSDATE, UID, USER, USERENV. If the users business rules require such data checking, then triggers can be used. The Check constraint does not protect the data columns and objects, nested tables, VARRY, ref, etc of the LOB data type. A single data column can have multiple Check constraint protection, and a Check constraint can protect multiple data columns. Create the Check constraint of the table, use the CREATE TABLE statement, change the constraint of the table, use the ALTER TABLE statement. Syntax