Oracle创建，添加，修改，删除

--新建表create table stu(       sno number(6),       sname varchar2(10),       sex varchar2(4),       age number(8),       enterdate date,       class varchar2(10),       email varchar2(10));--添加数据insert into stu values(1,'libai','男',34,'7-3月-2015','2班','[e-mail]');--修改(列名)字段名alter table tableName rename column oldCName to newCName; -- 修改字段名alter table student rename column sex to ssex;--修改（列值）字段值alter table tableName modify cloumnName 数据类型; -- 修改数据类型alter table student modify email varchar2(20);--添加列alter table student add score number(3);--删除列alter student drop column email;--修改表名rename stuent to student;--查询数据select * from student;--删除表drop table student;