oracle 插入一个从别处查询获得字段的值

一个表tb_inst_id_newold,是要往这个表里插入数据,里面有5个字段:new_inst_id,old_inst_id,last_modify_tlr_id,last_modify_prg_id,last_modify_t。前面的new_inst_id和old_inst_id的值是从另一个表tb_inst_id_newold_tmp表里的new_inst_id和old_inst_id来的,另外3三个字段分别填,‘init’,‘init’,to_char(sysdate,'yyyymmddhh24miss'),这语句该如何写,

insert into tb_inst_id_newold (new_inst_id,old_inst_id,last_modify_tlr_id,last_modify_prg_id,last_modify_t)
select new_inst_id,old_inst_id,'init','init',to_char(sysdate,'yyyymmddhh24miss') from tb_inst_id_newold_tmp where 1=1 and ...

原文地址:https://www.cnblogs.com/zztong/p/6695154.html