create table Records
(
id number primary key,
buyerId number not null,
sellerId number not null,
dealType number deault(1) check(dealType=0 or dealType=1) not null
);
第6行出现错误:
0RA-0907缺失右括号错误
这是我重新导入.sql文件是出现的错误,请大家帮我看一下是什么错误
------解决方案--------------------
-- deault 修改为 default就OK了!
create table Records
(
id number primary key,
buyerId number not null,
sellerId number not null,
dealType number default(1) check(dealType=0 or dealType=1) not null
);
------解决方案--------------------
- SQL code
14:01:27 SCOTT@tdwora > create table Records14:01:55 2 (14:01:55 3 id number primary key,14:01:55 4 buyerId number not null,14:01:55 5 sellerId number not null,14:01:55 6 dealType number default(1) check(dealType=0 or dealType=1) not null14:01:55 7 );表已创建。
------解决方案--------------------
------解决方案--------------------
哈哈,楼主太不细心了