Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ORA-00907: missing right parenthesis
Thanks, that fixed all of them except this table- CREATE TABLE PATIENT ( PATIENT_ID NUMBER(6) NOT NULL , FIRST_NAME VARCHAR2(10) NOT NULL , LAST_NAME VARCHAR2(15) NOT NULL , DOB DATE(10) NOT NULL , RELATIONSHIP VARCHAR2(10) NOT NULL , HOUSEHOLD_ID NUMBER(6) NOT NULL , CONSTRAINT PK_PATIENT_ID...- cfneadct
- Post #5
- Forum: Oracle: All versions
-
ORA-00907: missing right parenthesis
I have a script creating 10 tables This one and 2 others load fine. CREATE TABLE INSURANCE_COMPANY ( COMPANY_ID NUMBER(6) NOT NULL PRIMARY KEY , COMPANY_NAME VARCHAR2(20) NOT NULL , STREET_ADDRESS VARCHAR2(30) NOT NULL , CITY VARCHAR2(15) NOT NULL , STATE VARCHAR2(2) NOT NULL , ZIPCODE...- cfneadct
- Thread
- Replies: 6
- Forum: Oracle: All versions
