17,377
社区成员
发帖
与我相关
我的任务
分享
insert into tbl("Name","GongZi","Id_tbl",timestamp)
select 'ww','120',(select max("Id_tbl")+1 from tab) tb1,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual
insert into tbl("Name","GongZi","Id_tbl",timestamp)
select 'ww','120',max("Id_tbl")+1,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')
from tab