CREATE the code error free and do the needful implementations DROP TABLE PHARMACIST CASCADE CONSTRAINTS; CREATE TABLE
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Related Book For
Introduction to Java Programming, Comprehensive Version
ISBN: 978-0133761313
10th Edition
Authors: Y. Daniel Liang
Posted Date: