create table i_teacher_curriculum
(
curriculumId varchar2(30) not null,
i_teacher_id varchar2(5) default '' not null,
i_teacher_name varchar2(20) default '' not null ,
cur_column varchar2(50) default '' not null,
cur_column_introduce varchar2(500) default '' not null,
cur_time varchar2(50) default '' not null ,
cur_file varchar2(100) default '' not null ,
cur_title varchar2(100) default '' not null ,
primary key (curriculumId)
(
curriculumId varchar2(30) not null,
i_teacher_id varchar2(5) default '' not null,
i_teacher_name varchar2(20) default '' not null ,
cur_column varchar2(50) default '' not null,
cur_column_introduce varchar2(500) default '' not null,
cur_time varchar2(50) default '' not null ,
cur_file varchar2(100) default '' not null ,
cur_title varchar2(100) default '' not null ,
primary key (curriculumId)
);
建表的时候, 发生miss right parenthesit错误。
顺序有问题 将 i_teacher_id varchar2(5) not null default '' , 改成 i_teacher_id varchar2(5) default '' not null