常用SQL语句

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); （修改字段类型）