Shulou(Shulou.com)06/01 Report--

Create or replace procedure "TEST_PROCEDURE" is

Num int

Begin

/ / 1w cycles in the first layer

For i in 10000.. 19999 loop

/ / the second layer circulates 10 times

For j in 1..10 loop

Num:=i*10+j-1

/ / use | | concatenate strings

Insert into gh_xm_zxm values ('10967f5a-274a-4283-af20-91f9caf' | | to_char (I),' D5FD356FA5E943D8A686484' | | to_char (num), null)

End loop

End loop

Commit

End test_procedure

Call: call TEST_PROCEDURE ()

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.