Please create a PL/SQL procedure that checks availability of adoctor. The procedure has three input parameters: the doctor’sname, the start_time and length of a new appointment (the length isinterval day to second type), and checks whether the doctor has anyexisting appointment that overlaps with new appointment. If thereis no overlap, the procedure sets the output parameter to 1.Otherwise, the procedure sets the output to 0. Please do not countcanceled appointments when checking overlap.
— sample code to create the tables
drop table appointment_service cascade constraints;
drop table appointment cascade constraints;
drop table service cascade constraints;
drop table patient cascade constraints;
drop table doctor cascade constraints;
create table
PayPal Gateway not configured
PayPal Gateway not configured