是什么导致 SQL 中缺少右括号错误? [英] What is causing the missing right parenthesis error in SQL?

问题描述

几个小时以来，我一直在尝试运行以下 SQL 命令.我一直收到错误

I've been trying to run the following SQL command for hours now. I keep getting an error

ORA-00907:缺少右括号错误.

ORA-00907: missing right parenthesis error.

我知道这意味着某处存在语法错误，但我已经多次查看代码，但仍然无法弄清楚.任何帮助将不胜感激.

I know this means there is syntax error somewhere but I've gone over the code many times and still can't figure it out. Any help would be greatly appreciated.

CREATE TABLE Employees
(
    EmployeeID NUMBER (8,0) NOT NULL, 
    LastName VARCHAR2(20) NOT NULL, 
    FirstName VARCHAR2(10) NOT NULL, 
    Title VARCHAR2(30), 
    TitleOfCourtesy VARCHAR2(25), 
    BirthDate DATE(7),
    HireDate DATE(7),
    Address VARCHAR2(60), 
    City VARCHAR2(15), 
    Region VARCHAR2(15),
    PostalCode VARCHAR2(10), 
    Country VARCHAR2(15),
    HomePhone VARCHAR2(24), 
    Extension VARCHAR2(4), 
    Notes VARCHAR2(600), 
    ReportsTo NUMBER(8,0), 
    PhotoPath VARCHAR2(255),
    SIN CHAR(9), 

    CONSTRAINT Employees_EmployeeID_pk PRIMARY KEY (EmployeeID)
);

推荐答案

use Date 而不是 Date(7)

CREATE TABLE Employees(
EmployeeID NUMBER (8,0) NOT NULL, 
LastName VARCHAR2(20) NOT NULL, 
FirstName VARCHAR2(10) NOT NULL, 
Title VARCHAR2(30), 
TitleOfCourtesy VARCHAR2(25), 
BirthDate DATE,
HireDate DATE,
Address VARCHAR2(60),
City VARCHAR2(15), 
Region VARCHAR2(15),
PostalCode VARCHAR2(10), 
Country VARCHAR2(15),
HomePhone VARCHAR2(24), 
Extension VARCHAR2(4), 
Notes VARCHAR2(600), 
ReportsTo NUMBER(8,0), 
PhotoPath VARCHAR2(255),
SIN CHAR(9), 
CONSTRAINT Employees_EmployeeID_pk PRIMARY KEY (EmployeeID)
);

这篇关于是什么导致 SQL 中缺少右括号错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！