s_title.sql

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

DROP TABLE S_TITLE;
/
CREATE TABLE S_TITLE(
 TITLE		VARCHAR2(25)	NOT NULL
   );
/
INSERT INTO S_TITLE VALUES ('President');
INSERT INTO S_TITLE VALUES ('Sales Representative');
INSERT INTO S_TITLE VALUES ('Stock Clerk');
INSERT INTO S_TITLE VALUES ('VP, Administration');
INSERT INTO S_TITLE VALUES ('VP, Finance');
INSERT INTO S_TITLE VALUES ('VP, Operations');
INSERT INTO S_TITLE VALUES ('VP, Sales');
INSERT INTO S_TITLE VALUES ('Warehouse Manager');