oracle_11gr2_13 数据完整性 - 创建约束(主键,外键,check,非空) 和 索引的使用（Oracle_11gr2_13 data integrity - create constraints (primary keys, foreign keys, check, non empty) and index usage）.docVIP

oracle_11gr2_13 数据完整性 - 创建约束(主键,外键,check,非空) 和 索引的使用（Oracle_11gr2_13 data integrity - create constraints (primary keys, foreign keys, check, non empty) and index usage） Set operation The results of multiple query statements can be set operations, and the result sets should have the same field type, number, and order. Oracle has 4 set operations UNION: Union, the merger of the two operating results, remove duplicate parts The UNION ALL: Union, the merger of the two operating results, keep the duplicate part The MINUS: difference set removes the same part of the result from the previous operation The intersection of INTERSECT: takes the same part of the result of the two operations Search department 10 and department 20 for all positions. SELECT, job, FROM, employee, WHERE, deptno=10 UNION SELECT, job, FROM, EMP, WHERE, deptno=20; Are there any similar positions and salaries in the enquiry departments 10 and 20?. SELECT, job, Sal, FROM, employee, WHERE, deptno=10 INTERSECT SELECT, job, Sal, FROM, employee, WHERE, deptno=20 Queries appear only in department tables, but no sector numbers appear in the employee tables SELECT deptno FROM Dept MINUS SELECT deptno FROM employe The tutorial uses Oracle 11g Release 2 version Content: data integrity - create constraints (primary keys, foreign keys, CHECK, non empty) and index usage =============================================== Why do you need the primary key? The uniqueness of the primary key (the data cannot be duplicated), and basically every table will have the primary key Create a student table: CREATE, TABLE, xue_sheng (ID, integer, xing_ming, varchar (25), xing_bie, number, fen_shu, number, b_id, integer); INSERT, INTO, xue_sheng, VALUES (1,ZhanSan, 1,80,1); INSERT, INTO, xue_sheng, VALUES (2,LiSi, 1,90,2); INSERT, INTO, xue_sheng, VALUES (3,ZhanHong, 0,75,2); INSERT, INTO, xue_sheng, VALUES (4,ChenXiaoMing, 1,85,1); If you do not set the student number ID this unique, then there will be repeated student number phenome