INFO 2303 Database ProgrammingAssignment : 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 delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows. 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 NAMEDATEHIREDNUMBER(3),VARCHAR2(9),DATE,NUMBER(12),VARCHAR2(20),NUMBER(3),NUMBER(3),NUMBER(5),SALPERMONAREASUPERVISOR_IDCHGPERAPPTANNUAL BONUSCONSTRAINT DOCTOR_DOC_ID_PK PRIMARY KEY(DOC_ID));CREATE TABLE PATIENT(PT_IDPT LNAMEPT FNAMEPTDOBDOC IDNEXTAPPTDATELASTAPPTDATENUMBER(3),VARCHAR2(15),VARCHAR2(15),DATE,NUMBER(3),DATE,DATE,CONSTRAINT PATIENT_PT_ID PK PRIMARY KEY(PT_ID),CONSTRAINT PATIENT_DOC_ID_FK FOREIGNKEY(DOC_ID)REFERENCES DOCTOR);

Since I don't have access to the database, I am writing the general syntax of deleting the rows from…

Answered: Write an anonymous PL/SQL block that…

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

100%

INFO 2303 Database Programming

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 delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows.