demobld[sql 脚本文件].docVIP

-- -- Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved. -- -- NAME -- demobld.sql -- -- DESCRIPTION -- This script creates the SQL*Plus demonstration tables in the -- current schema. It should be STARTed by each user wishing to -- access the tables. To remove the tables use the demodrop.sql -- script. -- -- USAGE -- From within SQL*Plus, enter: -- START demobld.sql SET TERMOUT ON PROMPT Building demonstration tables. Please wait. SET TERMOUT OFF DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE BONUS; DROP TABLE SALGRADE; DROP TABLE DUMMY; CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT INTO EMP VALUES (7369, SMITH, CLERK, 7902, TO_DATE(17-DEC-1980, DD-MON-YYYY), 800, NULL, 20); INSERT INTO EMP VALUES (7499, ALLEN, SALESMAN, 7698, TO_DATE(20-FEB-1981, DD-MON-YYYY), 1600, 300, 30); INSERT INTO EMP VALUES (7521, WARD, SALESMAN, 7698, TO_DATE(22-FEB-1981, DD-MON-YYYY), 1250, 500, 30); INSERT INTO EMP VALUES (7566, JONES, MANAGER, 7839, TO_DATE(2-APR-1981, DD-MON-YYYY), 2975, NULL, 20); INSERT INTO EMP VALUES (7654, MARTIN, SALESMAN, 7698, TO_DATE(28-SEP-1981, DD-MON-YYYY), 1250, 1400, 30); INSERT INTO EMP VALUES (7698, BLAKE, MANAGER, 7839, TO_DATE(1-MAY-1981, DD-MON-YYYY), 2850, NULL, 30); INSERT INTO EMP VALUES (7782, CLARK, MANAGER, 7839, TO_DATE(9-JUN-1981, DD-MON-YYYY), 2450, NULL, 10); INSERT INTO EMP VALUES (7788, SCOTT, ANALYST, 7566, TO_DATE(09-DEC-1982, DD-MON-YYYY), 3000, NULL, 20); INSERT INTO EMP VALUES (7839, KING, PRESIDENT, NULL, TO_DATE(17-NOV-1981, DD-MON-YYYY), 5000, NULL, 10); INSERT INTO EMP VALUES (7844, TURNER, SALESMAN, 7698, TO_DATE(8-S