在PL/SQL 中执行以语句
CREATE TABLE OrderForm
( OFID number NOT NULL primary key,
CustomerID number NOT NULL,
CustomerName nvarchar2(50) collate Chinese_PRC_CI_AS NOT NULL,
CustomerTel nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
Corporation nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
BrandName nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
OrderDate nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
)
/ORA-00907: 缺失右括号
CREATE TABLE OrderForm
( OFID number NOT NULL primary key,
CustomerID number NOT NULL,
CustomerName nvarchar2(50) collate Chinese_PRC_CI_AS NOT NULL,
CustomerTel nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
Corporation nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
BrandName nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
OrderDate nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
)
/ORA-00907: 缺失右括号
CREATE TABLE OrderForm
( OFID number NOT NULL primary key,
CustomerID number NOT NULL,
CustomerName nvarchar2(50) collate Chinese_PRC_CI_AS NOT NULL,
CustomerTel nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
Corporation nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
BrandName nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
OrderDate nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL
)多了个逗号
OrderDate nvarchar2(50) COLLATE Chinese_PRC_CI_AS NULL,
逗号不是主要问题,collate Chinese_PRC_CI_AS 这个不是ORACLE的语法
SQL> CREATE TABLE OrderForm(
2 OFID number(10) primary key,
3 CustomerID number(10),
4 CustomerName nvarchar2(50) NOT NULL,
5 CustomerTel nvarchar2(50),
6 Corporation nvarchar2(50),
7 BrandName nvarchar2(50),
8 OrderDate nvarchar2(50))
9 /Table created
关于表的约束,你可以后来添加
alter