-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathInsert_records.sql
48 lines (31 loc) · 2.85 KB
/
Insert_records.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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
Prompt 'Insert records in departments table
INSERT INTO DEPARTMENTS (department_id,Department_name,location) values (deptseq.nextval,'Management','London');
INSERT INTO DEPARTMENTS (department_id,Department_name,location) values (deptseq.nextval,'Engineering','Cardiff');
INSERT INTO DEPARTMENTS (department_id,Department_name,location) values (deptseq.nextval,'Research & Development','Edinburgh');
INSERT INTO DEPARTMENTS (department_id,Department_name,location) values (deptseq.nextval,'Sales','Belfast');
Commit;
Prompt 'Records in departments table inserted
Prompt 'Insert records in Employees table
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'John Smith','CEO',null,to_date('01/01/1995','dd/mm/yyyy'),100000,1);
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'Jimmy Willis','Manager',90001,to_date('23/09/2003','dd/mm/yyyy'),52500,4);
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'Roxy Jones','Salesperson',90002,to_date('11/02/2017','dd/mm/yyyy'),35000,4);
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'Selwyn Field','Salesperson',90003,to_date('20/05/2015','dd/mm/yyyy'),32000,4);
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'David Hallett','Engineer',null,to_date('17/04/2018','dd/mm/yyyy'),40000,2);
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'Sarah Phelps','Manager',90001,to_date('21/03/2015','dd/mm/yyyy'),45000,2);
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'Louise Harper','Engineer',90006,to_date('01/01/2013','dd/mm/yyyy'),47000,2);
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'Tina Hart','Engineer',null,to_date('28/07/2014','dd/mm/yyyy'),45000,3);
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'Gus Jones','Manager',90001,to_date('15/05/2018','dd/mm/yyyy'),50000,3);
INSERT INTO EMPLOYEES (employee_id,employee_name,job_title,manager_id,date_hired,salary,department_id)
VALUES (empseq.nextval, 'Mildred Hall','Secretary',90001,to_date('12/10/1996','dd/mm/yyyy'),35000,1);
Update employees set manager_id = 90006 where employee_id = 90005;
Update employees set manager_id = 90009 where employee_id = 90008;
Prompt 'Records in employees table inserted