student1.txt

oracle操作基础基础基础基础基础基础基础基础基础基础基础基础

create table student1(
  sno varchar2(10),
  name varchar2(20) not null,
  sex varchar2(2),
  age  number(2),
  class varchar2(7) not null,
  constraint student1_pk_sno primary key(sno),
  constraint student1_check_sex check(sex in ('男','女')),
  constraint student1_check_age check(age between 16 and 20))