REM This script creates two tables Ang, Abt, BONUS1, and SALGRADE1,
REM INSERT INTO is used to input some test data
CREATE TABLE Abt
(AbtNr NUMBER(2) CONSTRAINT PK_Abt PRIMARY KEY,
DNAME VARCHAR2(14) ,
LOC VARCHAR2(13) ) ;
CREATE TABLE Ang
(AngNr NUMBER(4) CONSTRAINT PK_Ang PRIMARY KEY,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
AbtNr NUMBER(2) CONSTRAINT FK_AbtNr REFERENCES Abt);
INSERT
INTO Abt VALUES (10,'ACCOUNTING','Luzern');
INSERT
INTO Abt VALUES (20,'RESEARCH','Bale');
INSERT
INTO Abt VALUES (30,'SALES','Neuchatel');
INSERT
INTO Abt VALUES (40,'OPERATIONS','Bern');
INSERT
INTO Ang VALUES
(7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,30);
INSERT
INTO Ang VALUES
(7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30);
INSERT
INTO Ang VALUES
(7782,'NOURI','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10);
CREATE
TABLE BONUS1
(
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
SAL NUMBER,
COMM NUMBER ) ;
CREATE TABLE SALGRADE1
( GRADE NUMBER,
LOSAL NUMBER,
HISAL NUMBER );
INSERT
INTO SALGRADE1 VALUES (1,700,1200);
INSERT
INTO SALGRADE1 VALUES (2,1201,1400);
INSERT
INTO SALGRADE1 VALUES (3,1401,2000);
INSERT
INTO SALGRADE1 VALUES (4,2001,3000);
INSERT
INTO SALGRADE1 VALUES (5,3001,9999);