Question

Please write the commands in SQL Developer following the instructions below. Click on Write Submission and copy and paste the code into the submission box for this assignment. This assignment should be completed by November 16.

Add rows to the EMPLOYEES table from the last assignment with the following values:

123456789,Kitt,Eartha,Mae,'',222 Mt Vernon Rd,North,SC,29112

456789012,Gibson,Althea,NULL,26-JAN-1942,15 Adger Rd,Silver,SC,29102

789123456,Gillespie,John,Birks,21-OCT-1939,15 Third St,Cheraw,SC,29520

345678901,McNair,Ronald,Ervin,1-JUN-1978,36 Wilcox St,Lake City,SC,29650

678901234,Marion,Francis,NULL,15-JUN-1788,1 Pond Bluff Dr,Eutawville,SC,29048

Modify the ZIP code for Ronald McNair to 29560

Change the hire date for Eartha Kitt to 15-DEC-1943

Delete the record for Francis Marion

Save the changes permanently in the database.

Answer 1

Answer)
Add rows to the EMPLOYEES table from the last assignment with the following values:

insert into EMPLOYEES values (123456789,'Kitt','Eartha','Mae','','222 Mt Vernon Rd','North','SC',29112);

insert into EMPLOYEES values (456789012,'Gibson','Althea',NULL,'26-JAN-1942','15 Adger Rd','Silver','SC',29102);

insert into EMPLOYEES values (789123456,'Gillespie','John','Birks','21-OCT-1939','15 Third St','Cheraw','SC',29520);

insert into EMPLOYEES values (345678901,'McNair','Ronald','Ervin','1-JUN-1978','36 Wilcox St','Lake City','SC',296500);

insert into EMPLOYEES values (678901234,'Marion','Francis',NULL,'15-JUN-1788','1 Pond Bluff Dr','Eutawville','SC',29048);

UPDATE EMPLOYEES
SET ZIP = 29560
WHERE condition;

UPDATE EMPLOYEES
SET hire_date = '15-DEC-1943'
WHERE condition;

DELETE FROM EMPLOYEES WHERE condition;

The condition will be having the first name and the last name columns to compare. As we are not provided with the tables structure or the column name, thus we cannot form the condition statement.

commit;