Re: Creating a procedure to insert from one table to another

Posted by ErmanArslansOracleBlog on Jan 12, 2018; 12:34pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Creating-a-procedure-to-insert-from-one-table-to-another-tp4888p4899.html

Dont put commit there.

Commit after insert.. after ";" of insert.

you need to study sql.. You have syntax errors.


Example:

insert into tableB
Select * from
(Select A.*
from tableA A
left join tableB B
on a.id = B.id
where b.id is null )A;

commit;