Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Trying to create a table in sql and get this error: ORA-00907: missing right parenthesis Please Help. create table Driver( Driver_Licence char(15) primary key, SSN
Trying to create a table in sql and get this error: "ORA-00907: missing right parenthesis" Please Help.
create table Driver(
Driver_Licence char(15) primary key,
SSN int unique,
First_Name varchar(50) not null,
Last_Name varchar(50),
Birth_Date date DEFAULT '1900-01-01',
Hire_Date date COMMENT 'Hire_Date is the date that employee was first Hired',
State char(2),
INDEX (State),
CONSTRAINT CHK_Driver_HireDate CHECK(Hire_Date > Birth_Date)
);
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started