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
缺少括弧 怎么看都没发现 ！请各位大侠帮忙 ！不胜感激 ！ 谢谢！
------解决方案--------------------
- SQL code
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 /表已创建。--第四行少了个逗号