s_region.sql

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

DROP TABLE S_REGION;
/
CREATE TABLE S_REGION(
 ID            	NUMBER(7) 	NOT NULL,
 NAME		VARCHAR2(50)	NOT NULL
   );
/
INSERT INTO S_REGION VALUES (1,'North America');
INSERT INTO S_REGION VALUES (2,'South America');
INSERT INTO S_REGION VALUES (3,'Africa and Middle East');
INSERT INTO S_REGION VALUES (4,'Asia');
INSERT INTO S_REGION VALUES (5,'Europe');