create table students(
student_id number(5)
constraint student_pk primary key,
monitor_id number(5)
name varchar2(10) not null,
sex varchar2(6)
constraint sex_chk check (sex in('╧','')),
dob date,
specialty varchar2(10)
);提示信息: missing right parentthesis 缺少括弧 怎么看都没发现 !请各位大侠帮忙 !不胜感激 ! 谢谢!
student_id number(5)
constraint student_pk primary key,
monitor_id number(5)
name varchar2(10) not null,
sex varchar2(6)
constraint sex_chk check (sex in('╧','')),
dob date,
specialty varchar2(10)
);提示信息: missing right parentthesis 缺少括弧 怎么看都没发现 !请各位大侠帮忙 !不胜感激 ! 谢谢!
SQL> create table students(
2 student_id number(5)
3 constraint student_pk primary key,
4 monitor_id number(5),
5 name varchar2(10) not null,
6 sex varchar2(6)
7 constraint sex_chk check (sex in('╧','')),
8 dob date,
9 specialty varchar2(10)
10 )
11 /表已创建。
--第四行少了个逗号