表:
create table Single_answer_results_
(
SAR_id_ varchar(1000) primary key
);
insert into Single_answer_results_ values ("4bd6ac7530739b010130739e50a00001")
红色字体自增到1000 各位高手 怎么弄啊 万分火急。
create table Single_answer_results_
(
SAR_id_ varchar(1000) primary key
);
insert into Single_answer_results_ values ("4bd6ac7530739b010130739e50a00001")
红色字体自增到1000 各位高手 怎么弄啊 万分火急。
from dual connect by level<=1000;
(
SAR_id varchar(1000) primary key
);declare
v_sar_id number(18,0);
begin
v_sar_id := 1;
while v_sar_id <=1000 loop
insert into Single_answer_results(sar_id) values(lpad(v_sar_id,4,'0'));
v_sar_id := v_sar_id + 1;
end loop;
commit;
end;
/select count(*) from Single_answer_results;