1 创建两张表
create table t_source(
id number primary key,
testname varchar2(20),
createtime date,
flag varchar2(10)
);
create table t_target(
id number primary key,
testname varchar2(20),
createtime date,
flag varchar2(10)
);
2 插入三条数据
insert into t_source values(1,'测试数据1....1',sysdate-2,'N');
insert into t_source values(2,'测试数据1....2',sysdate-2,'N');
insert into t_source values(3,'测试数据1....3',sysdate-2,'N');
commit;
3 利用如下规则
insert into tableA (列1,列2,列3) select 列1,列2,常量 from tableB
insert into tableA (列1,列2,列3) select 列1,列2,’sss’ from tableB 【字符串常量】
insert into tableA (列1,列2,列3) select 列1,列2,123 from tableB 【数值常量】
insert into t_target select t.id,'123',sysdate-2,'Y' from t_source t