Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write an anonymous PL/SQL block that will update the salary of all doctors in the Pediatrics area by 1000 (Note: Current salary + 1000). Verify that the salary has been updated by issuing a select * from doctor where area = ‘Pediatrics’. You may have to run the select statement twice to check the data before and after the update. DROP TABLE PATIENT cascade constraints;DROP TABLE BILLING cascade constraints;DROP TABLE DOCTOR cascade constraints;DROP TABLE RENTAL cascade constraints;DROP TABLE MOVIE cascade constraints;DROP TABLE CUSTOMER cascade constraints;CREATE TABLE DOCTOR(DOC_IDDOC NAMEDATEHIREDSALPERMONAREASUPERVISOR IDCHGPERAPPTANNUAL BONUSNUMBER(3),VARCHAR2(9),DATE,NUMBER(12),VARCHAR2(20),NUMBER(3),NUMBER(3),NUMBER(5),CONSTRAINT DOCTOR_DOC_ID_PK PRIMARY KEY(DOC_ID)); INSERT INTO CUSTOMERVALUES(701, '549-8840', 'Williams', 'Tisha', 20.00,TO DATE('28-JUN-03'));INSERT INTO DOCTOR VALUES(432, 'Harrison',TO DATE('05-DEC-94'), 12000,'Pediatrics', 100, 75, 4500);INSERT INTO DOCTOR VALUES(509, 'Vester', TO DATE('09-JAN-00'), 8100,'Pediatrics', 432, 40, null);INSERT INTO DOCTOR VALUES(389, 'Lewis', TO DATE('21-JAN-96'), 10000,'Pediatrics', 432, 40, 2250);INSERT INTO DOCTOR VALUES(504, 'Cotner', TO_DATE('16-JUN-98'), 11500,'Neurology', 289, 85, 7500);INSERT INTO DOCTOR VALUES(235, 'Smith', TO_DATE('22-JUN-98'), 4550,'Family Practice', 100, 25, 2250);INSERT INTO DOCTOR VALUES(356, 'James', TO_DATE('01-AUG-98'), 7950,'Neurology', 289, 80, 6500);INSERT INTO DOCTOR VALUES(558, 'James', TO_DATE('02-MAY-95'), 9800,'Orthopedics', 876, 85, 7700);INSERT INTO DOCTOR VALUES(876, 'Robertson',TO DATE('02-MAR-95'), 10500,'Orthopedics', 100, 90, 8900);INSERT INTO DOCTOR VALUES(889, 'Thompson',TO DATE('18-MAR-97'), 6500,'Rehab', 100, 65, 3200);INSERT INTO DOCTOR VALUES(239, 'Pronger',TO DATE('18-DEC-99'), 3500,'Rehab',889, 40, null);INSERT INTO DOCTOR VALUES(289, 'Borque',TO DATE('30-JUN-89'), 16500,'Neurology', 100, 95, 6500);INSERT INTO DOCTOR VALUES(100, 'Stevenson',TO DATE('30-JUN-79'), 23500,'Director', null,null,null);

Hey there, I am writing the required solution based on the above given question. Please do find the…

Answered: Assignment : PL/SQL Practice Note:…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Assignment : PL/SQL Practice

Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL.

Write an anonymous PL/SQL block that will update the salary of all doctors in the Pediatrics area by 1000 (Note: Current salary + 1000). Verify that the salary has been updated by issuing a select * from doctor where area = ‘Pediatrics’. You may have to run the select statement twice to check the data before and after the update.