Oracle ORA-00902无效的数据类型错误 [英] Oracle ORA-00902 Invalid datatype error

问题描述

我正在尝试创建两个表，这将引发ORA-00902错误，无法弄清楚这里出了什么问题...

I am trying to create two tables, which is throwing ORA-00902 error, can't figure out what's wrong here...

CREATE TABLE VEHICLE_STORE
( 
  MODEL_NO VARCHAR2(12) NOT NULL,
  DESCRIPTION VARCHAR2(1000) NOT NULL,
  UNIT_PRICE NUMBER(10) NOT NULL,
  CURRENT_STOCK NUMBER(5) NOT NULL,
  CC NUMBER(3) NOT NULL,    
  CONSTRAINT vehicle_store_pk PRIMARY KEY(MODEL_NO)
);

CREATE TABLE VEHICLE_BOOKING
( 
  BOOKING_ID VARCHAR2(12) NOT NULL,
  CUSTOMER_NAME VARCHAR2(30) NOT NULL,
  EMAIL_ID VARCHAR2(30) NOT NULL,
  CONTACT NUMBER(15) NOT NULL,
  ADDRESS VARCHAR2(500) NOT NULL,
  PINCODE NUMBER(10) NOT NULL,
  MODEL_NO VARCHAR2(12) NOT NULL,
  DATE_OF_BOOKING VARCHAR2(12) NOT NULL,
  EXPECTED_DATE_OF_DELIVERY VARCHAR2(12) NOT NULL,  
  CONSTRAINT vehicle_booking_pk PRIMARY KEY(BOOKING_ID),
  CONSTRAINT vehicle_booking_fk FOREIGN_KEY(MODEL_NO) REFERENCES    VEHICLE_STORE(MODEL_NO)   
);

预先感谢...

推荐答案

将FOREIGN_KEY(MODEL_NO)更改为FOREIGN KEY (MODEL_NO)(无下划线).

Change FOREIGN_KEY(MODEL_NO) to FOREIGN KEY (MODEL_NO) (no underscore).

这篇关于Oracle ORA-00902无效的数据类型错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！