CREATE  the code error free and do the needful implementations 

DROP TABLE PHARMACIST CASCADE CONSTRAINTS;

CREATE TABLE PHARMACIST (
PHARM_ID NUMBER(10,0) PRIMARY KEY,
L_NAME VARCHAR2(25) NOT NULL,
F_NAME VARCHAR2(25) NOT NULL,
DOB DATE,
ACT_LIC VARCHAR (25) NOT NULL);

COMMIT;

 

ALTER TABLE PHARMACIST
ADD CONSTRAINT CHK_ACT_LIC (ACT_LIC) CHECK (ACT_LIC IN ('YES','NO'))
;

 

 

 

DROP TABLE PROVIDER CASCADE CONSTRAINTS;

 

CREATE TABLE PROVIDER (
PROV_NUM NUMBER(10,0) PRIMARY KEY,
L_NAME VARCHAR2(25) NOT NULL,
F_NAME VARCHAR2(25) NOT NULL,
DOB DATE,
SSN(9) NOT NULL
);

COMMIT;

ALTER TABLE PROVIDER
ADD CONSTRAINT PK_PROV_NUM (PROV_NUM)