oracle知识点

1.union和union all
union把查询结果并集处理，去重
union all把查询的结果并集处理，不去重
2.oracle批量插入

insert into student (sno,sname,sage,ssex) (select a.* from (
       (select 's012','test2','20','男' from dual)
       union all
       (select 's013','test3','22','男' from dual)
) a );

3.修改表字段长度(可以修改字段类型，但是表需要为空)

alter table student modify ssex  varchar2(10);

4.修改表字段名称

alter table student rename column ssex to sex ;