s_dept.sql

来自「SQL 语言二次开发实际经典开发实例希望对初学者有帮助」· SQL 代码 · 共 23 行

DROP TABLE S_DEPT;
/
CREATE TABLE S_DEPT (
 ID             NUMBER(7) 	NOT NULL,
 NAME		VARCHAR2(25)	NOT NULL,
 REGION_ID	NUMBER(7)
 );
/

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,'Operations',4);
INSERT INTO S_DEPT VALUES (45,'Operations',5);
INSERT INTO S_DEPT VALUES (50,'Administration',1);