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 thePediatrics area by 1000 (Note: Current salary + 1000). Verify that the salary has been updated by issuing aselect * from doctor where area = ‘Pediatrics’. You may have to run the select statement twice to check the data before and after the update.
Extracted text: 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_ID DOC NAME DATEHIRED SALPERMON AREA SUPERVISOR ID CHGPERAPPT ANNUAL BONUS NUMBER(3), VARCHAR2(9), DATE, NUMBER(12), VARCHAR2(20), NUMBER(3), NUMBER(3), NUMBER(5), CONSTRAINT DOCTOR_DOC_ID_PK PRIMARY KEY (DOC_ID));
Extracted text: INSERT INTO CUSTOMER VALUES(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);