Question

oracle 如何用语句造数,我想生成一批数字,从000000到999999,如何用oracle 的查询语句生成出来?

oracle 如何用语句造数,我想生成一批数字,从000000到999999,如何用oracle 的select语句生成出来?

Answer 1

declare
    maxrecords constant int:=999999;
     
    i int :=0;
     
begin
    for i in 0..maxrecords loop
      insert into  tablename (content) values(to_char(i,'000000') );   
              
           
    end loop;
dbms_output.put_line(' 成功录入数据！ ');
commit;
end;

Answer 2

create sequence ora_1 start with 0 maxvalue 9999999;
select ora_1.nextval from dual;--单条打印
要是想打印全的话找个超过999999条的表如表a，打印
select ora_1.nextval from 表a;
从0到9999999就都打印全啦！