Please take me away.
oracle 11g常用的数据库语句操作命令添加数据更新数据
上一篇 /
下一篇 2014-04-16 11:58:04
/ 个人分类:数据库知识
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;
收藏
举报
TAG: