|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
I have been struggling with this error for hours. Please help
SQL> CREATE TABLE kmol4_RequiredJob 2 (kmol4_RequiredJob_No CHAR(4) NOT NULL, 3 kmol4_RequiredJob_Title VARCHAR2(40), 4 kmol4_Client_CID CHAR(4) NOT NULL, 5 kmol4_RequiredJob_Description VARCHAR2(40), 6 kmol4_RequiredJob_StartDate DATE, 7 kmol4_RequiredJob_EndDate DATE, 8 kmol4_RequiredJob_DailyHours NUMBER(8) 9 kmol4_RequiredJob_Rate NUMBER(10,2) 10 PRIMARY KEY (kmol4_JRequiredJob_NO), 11 FOREIGN KEY (kmol4_Client_ID)REFERENCES kmol4_Client(kmol4_Client_ID)); (kmol4_RequiredJob_No CHAR(4) NOT NULL, * ERROR at line 2: ORA-00922: missing or invalid option |
|
#2
|
||||
|
||||
|
I assume the numbers to the left shouldn't be there
![]() I don't know SQL server so I'm going to guess that either CHAR or NOT NULL isn't valid in it? (I would think they are) |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Query thowing "missing or invalid option" (was Help) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|