Oracle练习用表

将此文件中内容复制，新建一个.sql文件，将此文件放到某盘根目录下，执行@ F:\table.sql（可以自己选择盘符，记得执行命令时，改为自己的盘符即可），执行后如显示提交完成，则导入成功。

CREATE TABLE s_dept(
id NUMBER(7) CONSTRAINT s_dept_id_nn NOT NULL,
name VARCHAR2(25) CONSTRAINT s_dept_name_nn NOT NULL,
region_id NUMBER(7),
CONSTRAINT s_dept_id_pk PRIMARY KEY (id),
CONSTRAINT s_dept_name_region_id_uk UNIQUE (name, region_id)
);

INSERT INTO s_dept VALUES (10, ‘Finance’, 1);
INSERT INTO s_dept VALUES (31, ‘Sales’, 1);
INSERT INTO s_dept VALUES (32, ‘Sales’, 2);
INSERT INTO s_dept VALUES (33, ‘Sales’, 3);
INSERT INTO s_dept VALUES (34, ‘Sales’, 4);
INSERT INTO s_dept VALUES (35, ‘Sales’, 5);
INSERT INTO s_dept VALUES (41, ‘Operations’, 1);
INSERT INTO s_dept VALUES (42, ‘Operations’, 2);
INSERT INTO s_dept VALUES (43, ‘Operations’, 3);
INSERT INTO s_dept VALUES (44, ‘Ope