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

Posted by Phindile on Jan 12, 2018; 10:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Creating-a-procedure-to-insert-from-one-table-to-another-tp4888p4897.html

Thanks for your response, yes I noticed i missed the "insert into" and it still gave some errors afterwards. So now I added "commit" after the "where" clause, and now I'm getting this error:
Error(14,22):PL/SQL:ORA-00923:FROM keyword not found where expected.

Thanks