I saw many others opened a question related to same problem however none of the answer addresses to the problem I have.
I am running below code on Oracle Live SQL and getting the error
ORA-00907: missing right parenthesis
create table CUST_ORDER (
ord_id NUMBER(38) CONSTRAINT cusordtb_ordid_pk PRIMARY KEY,
cust_id NUMBER(38) NOT NULL,
order_date DATE(12) NOT NULL
);
I am pretty sure I am not missing any parenthesis. Does anyone have the solution?
GMB :
The Oracle date datatype does not take a length.\nConsider:\ncreate table CUST_ORDER (\n ord_id NUMBER(38) CONSTRAINT cusordtb_ordid_pk PRIMARY KEY,\n cust_id NUMBER(38) NOT NULL,\n order_date DATE NOT NULL\n);\n",
2020-11-14T22:57:23