02 Oracle数据库对象 - 2 表.pptVIP

DEPT DEPTNO DNAME LOC ------ ---------- -------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON 插入到 20 MARKETING DALLAS FINANCE NEW YORK 不允许 (DEPTNO-20已经存在) 不允许(DEPTNO is null) 主码或主键约束可以定义在列或表上（ PRIMARY KEY ） SQL CREATE TABLE dept( 2 deptno NUMBER(2), 3 dname VARCHAR2(14), 4 loc VARCHAR2(13), 5 CONSTRAINT dept_dname_uk UNIQUE (dname), 6 CONSTRAINT dept_deptno_pk PRIMARY KEY(deptno)); DEPT DEPTNO DNAME LOC ------ ---------- -------- 10 ACCOUNTING NEW YORK 20 RESEA