-
Notifications
You must be signed in to change notification settings - Fork 1
/
oracleFile.sql
34 lines (31 loc) · 971 Bytes
/
oracleFile.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
CREATE SEQUENCE EMP_ID_SEQ START WITH 1;
create table EMPLOYEE2 ( empid INT NOT NULL ,
first_name VARCHAR(20) default NULL,
last_name VARCHAR(20) default NULL,
salary INT default NULL,
PRIMARY KEY (empid));
create table employee_address (
ADDID INT NOT NULL,
ADDRESS VARCHAR(20) default NULL,
EMPID_FK INT default NULL,
PRIMARY KEY (ADDID)
);
CREATE OR REPLACE TRIGGER EMPLOYEE2IDTRIGR
BEFORE
INSERT ON EMPLOYEE2
FOR EACH ROW
BEGIN
SELECT EMP_ID_SEQ.NEXTVAL
INTO :new.empid
FROM dual;
END;
/ -- this / should be in the next line, to execute procedure created
CREATE OR REPLACE TRIGGER EMPLOYEE_ADDRESS_TRIGR
BEFORE INSERT ON EMPLOYEE_ADDRESS
FOR EACH ROW
BEGIN
SELECT EMP_ID_SEQ.NEXTVAL
INTO:new.ADDID
FROM dual;
END;
/ -- this / should be in the next line, to execute procedure created