Oracle建表问题

[killsansan]

CREATE TABLE Borrow
(
Bcard char(20) NOT NULL,
Bname nvarchar2(10) NULL,
Bclass nvarchar2(10) NULL,
Bdpt nvarchar2(10) NULL
CONSTRAINT PK_BCARD PRIMARY KEY (Bcard) VALIDATE;

)

CREATE TABLE Book
(
Book char(20) NOT NULL,
Bbname nvarchar2(10) NOT NULL,
Bauth nvarchar2(10) NULL,
Bprice nvarchar2(10) NULL,
Bnum float NULL,
CONSTRAINT PK_BBOOK PRIMARY KEY (Bbook) VALIDATE;
)



CREATE TABLE Record
(
Rcard char(20) NOT NULL,
Rbook char(20) NOT NULL,
Rdate date NULL,
CONSTRAINT PK_RECORD PRIMARY KEY (Rcard,Rbook) VALIDATE,
CONSTRAINT FK_Bcard FOREIGN KEY (Bcard) REFERENCES Borrow(Bcard) VALIDATE,
CONSTRAINT FK_Bbook FOREIGN KEY (Bbook) REFERENCES Book(Bbook) VALIDATE;

)

这是个建3张表的脚本，但系统老是提示缺右括号，不能运行。不知道哪儿错了。望高手详解。

[wffffc]

CREATE TABLE Borrow
(
Bcard char(20) NOT NULL,
Bname nvarchar2(10) NULL,
Bclass nvarchar2(10) NULL,
Bdpt nvarchar2(10) NULL,
CONSTRAINT PK_BCARD PRIMARY KEY (Bcard) VALIDATE
);

CREATE TABLE Book
(
Book char(20) NOT NULL,
Bbname nvarchar2(10) NOT NULL,
Bauth nvarchar2(10) NULL,
Bprice nvarchar2(10) NULL,
Bnum float NULL,
CONSTRAINT PK_BBOOK PRIMARY KEY (Bbook) VALIDATE
);


CREATE TABLE Record
(
Rcard char(20) NOT NULL,
Rbook char(20) NOT NULL,
Rdate date NULL,
CONSTRAINT PK_RECORD PRIMARY KEY (Rcard,Rbook) VALIDATE,
CONSTRAINT FK_Bcard FOREIGN KEY (Bcard) REFERENCES Borrow(Bcard) VALIDATE,
CONSTRAINT FK_Bbook FOREIGN KEY (Bbook) REFERENCES Book(Bbook) VALIDATE
);

[wiler]

分号放错地方了

[wangbin1986]

是这么回事

[燃烧的岁月_]

CREATE TABLE Borrow
(
Bcard char(20) NOT NULL,
Bname nvarchar2(10) NULL,
Bclass nvarchar2(10) NULL,
Bdpt nvarchar2(10) NULL
CONSTRAINT PK_BCARD PRIMARY KEY (Bcard) VALIDATE;

);

CREATE TABLE Book
(
Book char(20) NOT NULL,
Bbname nvarchar2(10) NOT NULL,
Bauth nvarchar2(10) NULL,
Bprice nvarchar2(10) NULL,
Bnum float NULL,
CONSTRAINT PK_BBOOK PRIMARY KEY (Bbook) VALIDATE;
);


CREATE TABLE Record
(
Rcard char(20) NOT NULL,
Rbook char(20) NOT NULL,
Rdate date NULL,
CONSTRAINT PK_RECORD PRIMARY KEY (Rcard,Rbook) VALIDATE,
CONSTRAINT FK_Bcard FOREIGN KEY (Bcard) REFERENCES Borrow(Bcard) VALIDATE,
CONSTRAINT FK_Bbook FOREIGN KEY (Bbook) REFERENCES Book(Bbook) VALIDATE;

) ;
分号放错地方了

[killsansan]

改了一下，结果还是提示括号缺失什么的。 能帮忙重写个么，就用上面定义好的表和属性。

[killsansan]

改了一下，结果还是提示括号缺失什么的。 能帮忙重写个么，就用上面定义好的表和属性。

[butchroller]

CREATE TABLE Borrow
(
Bcard char(20) NOT NULL,
Bname nvarchar2(10) NULL,
Bclass nvarchar2(10) NULL,
Bdpt nvarchar2(10) NULL,
CONSTRAINT PK_BCARD PRIMARY KEY (Bcard) VALIDATE
)
;
CREATE TABLE Book
(
Bbook char(20) NOT NULL,
Bbname nvarchar2(10) NOT NULL,
Bauth nvarchar2(10) NULL,
Bprice nvarchar2(10) NULL,
Bnum float NULL,
CONSTRAINT PK_BBOOK PRIMARY KEY (Bbook) VALIDATE
)
;

CREATE TABLE Record
(
Rcard char(20) NOT NULL,
Rbook char(20) NOT NULL,
Rdate date NULL,
CONSTRAINT PK_RECORD PRIMARY KEY (Rcard,Rbook) VALIDATE,
CONSTRAINT FK_Bcard FOREIGN KEY (Rcard) REFERENCES Borrow(Bcard) VALIDATE,
CONSTRAINT FK_Bbook FOREIGN KEY (Rbook) REFERENCES Book(Bbook) VALIDATE
) 
;

[eviler]

一个create当作一个完整的语句，要以 ； 号结束

[killsansan]

Thank you!