Sunday, February 5, 2012

How to do incremental data load from one table to another table in oracle?

Please use the outer join to do the incremental load from one table to another table.

insert into dup_emp
select a.* from emp a,dup_emp b
where a.EMPNO=b.empno(+)
and b.empno is null

No comments:

Post a Comment