SQL USING ORACLE - Relational Database Management Systems - page 145

12-May-72 Sr. Lecturer 11-Jan-75 Lecturer 10-Feb-77 Lecturer

9-Jul-82 Lecturer 5-May-76 Lecturer
8-Jun-87 Technician
7-Jan-86 Technician
7-Jan-88 Lab Astt.

Department Address CSE H. No 23 JP Nag. ECE H. No 56 SP Nag. ECE H.No 64 SP Nag.
CSE H.No 69 SP Nag. CSE H.No 543 JS Nag

EE H.No 558 JS Nag ME H.No 513 JS Nag CSE H. No 29 JP Nag. ECE H. No 65 JP Nag.

City Phone Jalandhar
Ludhiana
Ludhiana
Ludhiana
Amritsar
Amritsar
Amritsar
Jalandhar
Jalandhar

INSERT INTO Staff (StaffID, Name, DOB,Designation, Department,Address,City,Phone)
VALUES

( 101, 'Manoj Kumar','23-Jun-66','HOD','CSE','H. No 23 JP

Nag.','Jalandhar','');

INSERT INTO Staff (StaffID, Name, DOB,Designation, Department,Address,City,Phone)
VALUES (102, 'Aman Kumar','12-May-72','Sr. Lecturer','ECE','H. No 56 SP Nag.',
'Ludhiana', '');

INSERT INTO Staff (StaffID, Name, DOB,Designation, Department,Address,City,Phone)
VALUES(103,'Nigam', '11-Jan-75','Lecturer','ECE', 'H.No 64 SP Nag. Ludhiana','');

INSERT INTO Staff (StaffID, Name, DOB,Designation, Department,Address,City,Phone)
VALUES(104,'Ajay Kumar','10-Feb-77','Lecturer','CSE','H.No 69 SP Nag.' , 'Ludhi-
ana' ,'');

INSERT INTO Staff (StaffID, Name, DOB,Designation, Department,Address,City,Phone)
VALUES(105,'Rohit','9-Jul-82','Lecturer','CSE',' H.No 543 JS Nag','Amritsar','');