Oracle Level的使用

create table temp as select SUBSTR('111120180115000001',1,2)||TO_CHAR(TO_NUMBER(SUBSTR('111120180115000001',3)) + level) as a,

SUBSTR('111120180115000001',1,2)||TO_CHAR(TO_NUMBER(SUBSTR('111120180115000002',3)) + level) as b,
SUBSTR('111120180115000001',1,2)||TO_CHAR(TO_NUMBER(SUBSTR('111120180115000003',3)) + 3) as c
  from dual connect by level < 30000;