oracle创建和删除约束（Oracle creates and deletes constraints）.docVIP

oracle创建和删除约束（Oracle creates and deletes constraints） Data integrity constraints: creation, deletion, statements of primary keys, foreign keys, and various constraints ORACLE constraints on database integrity: Three ways to maintain data integrity: ORACLE integrity constraints, database triggers, application code. ORACLE integrity constraints should be used as far as possible, reliable and efficient, easy to modify, and flexible to use, recorded in the data dictionary. ORACLE five constraints: Non empty not null, columns defined cannot be empty. Can only be defined at column level Unique, unique. The column or column values defined by each row in the table cannot be the same The primary key primary key does not include null values. The primary key uniquely identifies each row in the table, and a column or column is combined as a primary key The foreign key foreign key indicates that a column or column of combinations is foreign key to maintain referential integrity between table chilD table and master table parent table referential integrity The condition constraint check, each line in the table has to satisfy the constraint. Constraints are added to the table to create a table that can be defined 1. query constraint The query table has constraints and displays constraint names: information that displays constraints on the table column BYS@bys1select, a.constraint_name, a.column_name, from, user_cons_columns, a, user_constraints, B, where, a.table_name = upper (AA); Enter, value, for, aa:, EMP Old, 1:, select, a.constraint_name, a.column_name, from, user_cons_columns, a, user_constraints, B, where, a.table_name = upper (AA) New, 1:, select, a.constraint_name, a.column_name, from, user_cons_columns, a, user_constraints, B, where, a.table_name = upper (emp) CONSTRAINT_NAME COLUMN_NAME --------------------------------------------- PK_EMPNO EMPNO Is there a primary key constraint in the table? BYS@bys1select a.constraint_name, a.column_name from user_cons_columns a, use