diff options
Diffstat (limited to 'reladminif/test/demobld.sql')
-rw-r--r-- | reladminif/test/demobld.sql | 125 |
1 files changed, 125 insertions, 0 deletions
diff --git a/reladminif/test/demobld.sql b/reladminif/test/demobld.sql new file mode 100644 index 0000000..0895e87 --- /dev/null +++ b/reladminif/test/demobld.sql @@ -0,0 +1,125 @@ +/* +* This file is part of rasdaman community. +* +* Rasdaman community is free software: you can redistribute it and/or modify +* it under the terms of the GNU General Public License as published by +* the Free Software Foundation, either version 3 of the License, or +* (at your option) any later version. +* +* Rasdaman community is distributed in the hope that it will be useful, +* but WITHOUT ANY WARRANTY; without even the implied warranty of +* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +* GNU General Public License for more details. +* +* You should have received a copy of the GNU General Public License +* along with rasdaman community. If not, see <http://www.gnu.org/licenses/>. +* +* Copyright 2003, 2004, 2005, 2006, 2007, 2008, 2009 Peter Baumann / +rasdaman GmbH. +* +* For more information please see <http://www.rasdaman.org> +* or contact Peter Baumann via <baumann@rasdaman.com>. +*/ +-- +-- $Header: /home/rasdev/CVS-repository/rasdaman/reladminif/test/demobld.sql,v 1.3 2003/12/27 23:11:46 rasdev Exp $ +-- Copyright (c) Oracle Corporation 1988, 1993. All Rights Reserved. +-- +-- +-- This script creates the SQL*Plus demonstration tables. +-- +-- It should be STARTed by each user wishing to access the tables. +-- + +set termout on +prompt Building demonstration tables. Please wait. +set termout off +set feedback off + +ALTER SESSION SET NLS_LANGUAGE = AMERICAN; +ALTER SESSION SET NLS_TERRITORY = AMERICA; + +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,'17-DEC-80',800,NULL,20); +INSERT INTO EMP VALUES + (7499,'ALLEN','SALESMAN',7698,'20-FEB-81',1600,300,30); +INSERT INTO EMP VALUES + (7521,'WARD','SALESMAN',7698,'22-FEB-81',1250,500,30); +INSERT INTO EMP VALUES + (7566,'JONES','MANAGER',7839,'2-APR-81',2975,NULL,20); +INSERT INTO EMP VALUES + (7654,'MARTIN','SALESMAN',7698,'28-SEP-81',1250,1400,30); +INSERT INTO EMP VALUES + (7698,'BLAKE','MANAGER',7839,'1-MAY-81',2850,NULL,30); +INSERT INTO EMP VALUES + (7782,'CLARK','MANAGER',7839,'9-JUN-81',2450,NULL,10); +INSERT INTO EMP VALUES + (7788,'SCOTT','ANALYST',7566,'09-DEC-82',3000,NULL,20); +INSERT INTO EMP VALUES + (7839,'KING','PRESIDENT',NULL,'17-NOV-81',5000,NULL,10); +INSERT INTO EMP VALUES + (7844,'TURNER','SALESMAN',7698,'8-SEP-81',1500,0,30); +INSERT INTO EMP VALUES + (7876,'ADAMS','CLERK',7788,'12-JAN-83',1100,NULL,20); +INSERT INTO EMP VALUES + (7900,'JAMES','CLERK',7698,'3-DEC-81',950,NULL,30); +INSERT INTO EMP VALUES + (7902,'FORD','ANALYST',7566,'3-DEC-81',3000,NULL,20); +INSERT INTO EMP VALUES + (7934,'MILLER','CLERK',7782,'23-JAN-82',1300,NULL,10); + +CREATE TABLE DEPT + (DEPTNO NUMBER(2), + DNAME VARCHAR2(14), + LOC VARCHAR2(13) ); + +INSERT INTO DEPT VALUES + (10,'ACCOUNTING','NEW YORK'); +INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS'); +INSERT INTO DEPT VALUES + (30,'SALES','CHICAGO'); +INSERT INTO DEPT VALUES + (40,'OPERATIONS','BOSTON'); + +CREATE TABLE BONUS + ( + ENAME VARCHAR2(10), + JOB VARCHAR2(9), + SAL NUMBER, + COMM NUMBER + ); + +CREATE TABLE SALGRADE + ( GRADE NUMBER, + LOSAL NUMBER, + HISAL NUMBER ); + +INSERT INTO SALGRADE VALUES (1,700,1200); +INSERT INTO SALGRADE VALUES (2,1201,1400); +INSERT INTO SALGRADE VALUES (3,1401,2000); +INSERT INTO SALGRADE VALUES (4,2001,3000); +INSERT INTO SALGRADE VALUES (5,3001,9999); + +CREATE TABLE DUMMY + ( DUMMY NUMBER ); + +INSERT INTO DUMMY VALUES (0); + +COMMIT; + +EXIT; |