create table student (
  sno char(8),
  sname char(16) unique,
  sage int,
  sgender char (1),
  primary key ( sno )
);

create index stunameidx on student ( sname );

insert into student values ('12345678','wy',22,'M');