insert into t1(id,列1,列2,列9,列4,列5,列6) select id,列1,列2,sysdate,'固定值',列5,列6
insert into t1(id,列1,列2,列9,列4,列5,列6) select id,列1,列2,sysdate,'固定值',列5,列6 from t2 where id = ...
insert into t1(id,列1,列2,列5,列6,列9) select id,列1,列2,列5,列6,to_char(sysdate,'DD-MON-YY HH24:MI:SS') from t2
如果时间列列4为日期型(DATE)的: insert into t1(id,列1,列2,列4,列5,列6) select id,列1,列2,sysdate,列5,列6 from t2; 如果为字符型(VARCHAR2)的: insert into t1(id,列1,列2,列4,列5,列6) select id,列1,列2,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),列5,列6 from t2
insert into t1(列1,列2,列5,列6,列9) select 列1,列2,列5,列6,sysdate from t2
insert into t1(id,列1,列2,列4,列5,列6) select id,列1,列2,sysdate,列5,列6 from t2;
from t2 where id = ...
select id,列1,列2,列5,列6,to_char(sysdate,'DD-MON-YY HH24:MI:SS') from t2
insert into t1(id,列1,列2,列4,列5,列6)
select id,列1,列2,sysdate,列5,列6 from t2;
如果为字符型(VARCHAR2)的:
insert into t1(id,列1,列2,列4,列5,列6)
select id,列1,列2,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),列5,列6 from t2
select 列1,列2,列5,列6,sysdate from t2