前言:
现时朋友们对“oracle 更改字段大小”大致比较关怀,同学们都想要学习一些“oracle 更改字段大小”的相关内容。那么小编在网络上汇集了一些对于“oracle 更改字段大小””的相关文章,希望咱们能喜欢,小伙伴们一起来了解一下吧!create or replace procedure insert is
flowid number(10);
i number;
begin
i:=0;
flowid:=0108004084;
while i<10000 LOOP
insert into zz_xx_list values ('80D2336800095F15D011D047E50', '555', '343', '', '', 'wjfeiofweifowejfwaeofjweflawejfwaewjfeiofweifowejfwaeofjweflawejfwaeflwefjwefwifwafwjlfwefiaweflwaefjawjfwfwjhgfdsazx'||to_char(flowid)||'cvbnm12345678900987654321lwefjwefwifwafwjlfwefiaweflwaefjawjfwfwnljfweweefefwefwefwezfwefwefbqzqwertyuioplkjhgfdsazxcvbnmqwe1123450987654321', '', '85357111001F569AE'||to_char(flowid), '85357111001F569AE'||to_char(flowid), '', '', null, '', '11', '', '', '', '', '11', '11', null, to_date('18-10-2018 11:27:46', 'dd-mm-yyyy hh24:mi:ss'), to_date('18-10-2018 11:27:46', 'dd-mm-yyyy hh24:mi:ss'), '11', '11', '', '', '11', '', '', '其它', '', '', '', '11', '', '', '', '', null, null, '', '', null, '333', '', null, '80D232D3001045454D48150', '1', '', '', to_date('18-10-2018', 'dd-mm-yyyy'), '', '', null, '11', '', '', '3333', '', '', null, '', '', '', '', '', '', '', '', '', '2', '2', '2', '', '', null, '', null, '', '', '3', null, 1.00000);
commit;
flowid:=flowid+1;
i:=i+1;
end LOOP;
end insert;
create or replace procedure select is
flowid number(10);
i number;
begin
i:=0;
flowid:=0108004084;
while i<100000 LOOP
select * from zz_xx_list where FLOWID='85357111001F569AE'||to_char(flowid);
commit;
flowid:=flowid+1;
i:=i+1;
end LOOP;
end insert;
create or replace procedure test is
flowid number(10);
i number;
begin
i:=0;
flowid:=0108004084;
while i<100000 LOOP
update zz_xx_list set BZ='bianle' where flowid='85357111001F569AE'||to_char(flowid);
commit;
flowid:=flowid+1;
i:=i+1;
end LOOP;
end test;
create or replace procedure delete is
flowid number(10);
i number;
begin
i:=0;
flowid:=0108004084;
while i<100000 LOOP
delete from zz_xx_list where flowid='85357111001F569AE'||to_char(flowid);
commit;
flowid:=flowid+1;
i:=i+1;
end LOOP;
end delete;
创建索引
create index TEST_TEST on zz_xx_list(bz);
修改字段长度
alter table zz_xx_list modify (BZ varchar2(2000));
标签: #oracle 更改字段大小