1.查询语句
select count(*) from aa;
select * from aa;
2.删除语句
truncate table aa;
delete from aa;
3.插入语句
insert into DATA_00222 select * from DATA_MPITEST where ROWNUM <= 100000;
insert into aa(id,name) values("","");
4.更新语句
update DATA_00222 set BIRTH=sysdate;
5.修改语句
alter table tablename modify filedname varchar2(20); (修改字段类型)