如果开始加了50条,就原来的基础上再进行递增
insert into vip_cust_md
( id,
mum,
caeated,
created_by)
(select
'aa'||LPAD(ROWNUM+50,9,'0'),
'5600021234521',
sysdate,
'sys',from dual connect by <=20);
如果开始加了50条,就原来的基础上再进行递增
insert into vip_cust_md
( id,
mum,
caeated,
created_by)
(select
'aa'||LPAD(ROWNUM+50,9,'0'),
'5600021234521',
sysdate,
'sys',from dual connect by <=20);