Oracle中重新导入.sql.文件出现的问题
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
);
[解决办法]
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 );表已创建。
[解决办法]