/* $Id: demodata.sql,v 1.1 1998/03/26 21:56:57 yxia Exp $		*/
/* $Log: demodata.sql,v $
# Revision 1.1  1998/03/26  21:56:57  yxia
# Initial revision
#
# Revision 1.1  1997/09/03  21:52:01  bgutierr
# Initial revision
#
# Revision 1.4  1997/07/09  23:41:07  aclarke
# log: OCA 2.0.2.11.0 files.
#
# Revision 1.1  1996/02/06  18:04:35  kmuniasa
# log: Initial version for d2 1.3 release.
#	*/
/* Copyright (c) 1993, 1994 by the Oracle Corporation 			*/

/* -------------------------------------------------------------------- */
/* NAME         DEMODATA.SQL -SQL script to insert data into demo tables*/
/*                                                                      */
/* NOTES        Must run XXXDMBLD.sql first before executing this script*/
/*              This script uses ODBC compliant SQL and is thus portable*/
/*              among databases.                                        */
/*                                                                      */
/* 			                                                */
/*                                                                      */
/* MODIFIED								*/
/*  									*/
/* -------------------------------------------------------------------- */

/* Log file spooled to current working directory 			*/

SPOOL DEMODATA1.LOG


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');

INSERT INTO EMP VALUES (7369,'SMITH','CLERK',7902,{d '1980-12-17'},800,0,20);
INSERT INTO EMP VALUES (7499,'ALLEN','SALESMAN',7698,{d '1981-02-20'},1600,300,30);
INSERT INTO EMP VALUES (7521,'WARD','SALESMAN',7698,{d '1981-02-22'},1250,500,30);
INSERT INTO EMP VALUES (7566,'JONES','MANAGER',7839,{d '1981-04-02'},2975,0,20);
INSERT INTO EMP VALUES (7654,'MARTIN','SALESMAN',7698,{d '1981-09-28'},1250,1400,30);
INSERT INTO EMP VALUES (7698,'BLAKE','MANAGER',7839,{d '1981-05-01'},2850,0,30);
INSERT INTO EMP VALUES (7782,'CLARK','MANAGER',7839,{d '1981-06-09'},2450,0,10);
INSERT INTO EMP VALUES (7788,'SCOTT','ANALYST',7566,{d '1981-12-09'},3000,0,20);
INSERT INTO EMP VALUES (7839,'KING','PRESIDENT',0,{d '1981-11-17'},5000,0,10);
INSERT INTO EMP VALUES (7844,'TURNER','SALESMAN',7698,{d '1981-09-08'},1500,0,30);
INSERT INTO EMP VALUES (7876,'ADAMS','CLERK',7788,{d '1983-01-12'},1100,0,20);
INSERT INTO EMP VALUES (7900,'JAMES','CLERK',7698,{d '1981-12-03'},950,0,30);
INSERT INTO EMP VALUES (7902,'FORD','ANALYST',7566,{d '1981-12-03'},3000,0,20);
INSERT INTO EMP VALUES (7934,'MILLER','CLERK',7782,{d '1981-01-23'},1300,0,10);
 
COMMIT

SPOOL OFF
