龙空技术网

oracle存储过程案例

妥妥滴IT工具人 70

前言:

现时朋友们对“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 更改字段大小