insert into hr_employe
select * from HR_EMPLOYE as of timestamp to_TImeSTamp(sysdate-1) t
where not exists (select 1 from Hr_Employe h where t.empid = h.empid )
select description from digits
versions between timestamp minvalue and maxvalue;
本文介绍了一种使用SQL在确保数据唯一性的前提下进行批量插入的方法,并通过时间戳来标记记录的有效性,同时展示了如何查询指定范围内的版本信息。
insert into hr_employe
select * from HR_EMPLOYE as of timestamp to_TImeSTamp(sysdate-1) t
where not exists (select 1 from Hr_Employe h where t.empid = h.empid )
select description from digits
versions between timestamp minvalue and maxvalue;
4126
1184

被折叠的 条评论
为什么被折叠?