SQL错误-缺少关键字 [英] SQL Error - missing keyword

问题描述

此查询有什么问题:我收到以下错误消息

Whats wrong with this query : I am getting following error

SQL错误:ORA-00905:缺少关键字 00905. 00000-缺少关键字"

SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword"

它在第4行显示错误.请指教

it says error at 4th row. Please advise

CREATE TABLE ORDERS
(
ID INT        NOT NULL,
ord_date    DATE, 
AMOUNT     double,
CUSTOMER_ID INT references CUSTOMERS(ID),
PRIMARY KEY (ID)
);

推荐答案

您错过了在double数据类型中添加precision

You missed to add precision in double datatype

CREATE TABLE ORDERS
(
   ID INT        NOT NULL,
   ord_date    DATE, 
   AMOUNT     double precision,
   CUSTOMER_ID INT references CUSTOMERS(ID),
   PRIMARY KEY (ID)
);

SQLFIDDLE DEMO

SQLFIDDLE DEMO

有关更多信息， 在此处检查

这篇关于SQL错误-缺少关键字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！