Oracle第二章习题及答案.docxVIP

一、基于自己创建表的操作1：创建一张学生表student，拥有stuid,stuname,sex,三个字段，其中stuid为主键。create table student( stuid int primary key, stuname VARCHAR(20), sex VARCHAR(20))2：为该表增加一个新列score。alter table student add(score varchar(10));3：修改该表score列名为stuscore。alter table student rename column score to stuscoree;4：为student表插入5条记录。insert into student values(1,张三丰,男,80);insert into student values(2,阿悄,女,70);insert into student values(3,陈龙,男,90);insert into student values(4,章子怡,女,50);insert into student values(5,张卫健,男,60);5：查询student表中的全部数据，其中列名为中文。select STUID as 学号,STUNAME as 姓名 ,SEX as 性别,STUSCOREE as 分数 from