CODEWITHSUNDEEP
sqloracle-databaseconstraints
TitanC
TitanC

Reputation: 139

Creating a Table in SQL with constraints

I am trying to create a table. I am unable to compile it successfully. Could someone please point me in the right direction

Here is my code:

 CREATE TABLE TESTING_TODAY
 (
 EMP_NUM NUMBER(5, 0) NOT NULL, 
 RTG_CODE CHAR(5 BYTE) NOT NULL,
 EARNED_DATE DATE NOT NULL
 CONSTRAINT PK_TESTING_TODAY PRIMARY KEY CLUSTERED 
 (
   [EMP_NUM] ASC,
   [RTG_CODE] ASC
 )
 );
 COMMIT;

Upvotes: 0

Views: 1004

Answers (1)

user330315
user330315

Reputation:

CLUSTERED is invalid in Oracle and [,] are invalid in SQL identifiers:

CREATE TABLE TESTING_TODAY
(
   EMP_NUM NUMBER(5, 0) NOT NULL, 
   RTG_CODE CHAR(5 BYTE) NOT NULL,
   EARNED_DATE DATE NOT NULL,
   CONSTRAINT PK_TESTING_TODAY PRIMARY KEY (EMP_NUM,RTG_CODE)
);
COMMIT;

Upvotes: 3

Related Questions