problem description
I want the XH field to increase from 1, because it is of varchar type, so I use this way, but I find that the XH field in my data table starts to increase from 217, why
the environmental background of the problems and what methods you have tried
related codes
/ / Please paste the code text below (please do not replace the code with pictures)
declare
j number;
I number;
begin
iVl1;
for i in 1.. 3040000 loop
insert into g_jdcl (XH, HPZL, HPHM, CLXH, CLLX, CSYS, CLPP1) values (to_char (j),"01 Leng Leng "Yue A" | dbms_random.string
IF Mod(j,5000)=0
THEN
COMMIT;
dbms_output.put_line("over!");
END IF; end loop;
end;
I want the XH field to increase from 1, because it is of varchar type, so I use this way, but I find that the XH field in my data table starts to increase from 217, why