oracle 11g常用的数据库语句操作命令添加数据更新数据

select * from sys_account for update;
select * from log_operlog where user_name like 'a%';
select * from tm_provider for update
select * from tm_model where model_code >'100';

declare i int;
begin
     i:=100;
     while i < 200
     loop
         insert into tm_provider (tp_code,tp_name,tp_tel,tp_man_name,addr,reg_time,state)
         values(i,i,'13527844474','TT','地址','20120711122400','0');
         i := i + 1;
         commit;
         end loop;
     end;

delete tm_provider where tp_man_name='TT'

delete tm_model where model_code >'100';
declare i int;
begin
     i:=1;
     while i < 100
     loop
         insert into tm_model (model_code,tp_code,type_name,state)
         values(i,'2LL',i,'0');
         i := i + 1;
         commit;
         end loop;
     end;

select count(*) from tm_model

select * from tm_model
select * from tm_provider for update

select * from log_operlog
select * from log_operlog where user_name='lin' order by oper_time desc;