select to_char('00000000000000000299'+1,'00000000000000000000') as id from dual;
id
-----------------------------------------
00000000000000000300
insert intotable1 (pi_id, form_id, other_col)
select to_char(pi_id+1,'00000000000000000000'),'1qh', other_col
from table1 where form_id = '1'; |