create table person
(
pid varchar2(10) primary key,
pname varchar2(40) unique not null,
page number(2) check (page between 0 and 150),
psex char(2) check (psex in('男','女')) default '男'
);
-------------------------------------------------------------
psex char(2) check (psex in('男','女'))default '男'
)ORA-00907: 缺少右括号
(
pid varchar2(10) primary key,
pname varchar2(40) unique not null,
page number(2) check (page between 0 and 150),
psex char(2) check (psex in('男','女')) default '男'
);
-------------------------------------------------------------
psex char(2) check (psex in('男','女'))default '男'
)ORA-00907: 缺少右括号
(
pid varchar2(10) primary key,
pname varchar2(40) unique not null,
page number(2) check (page between 0 and 150),
psex char(2) default '男' check (psex in('男','女'))
);
SQL> create table person
2 (
3 pid varchar2(10) primary key,
4 pname varchar2(40) unique not null,
5 page number(2) check (page between 0 and 150),
6 psex char(2) default '男' check (psex in('男','女'))
7 );表已创建。
default 在 check 之前!