Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00926: missing VALUES keyword

601989Aug 26 2009 — edited Aug 26 2009
Hi,

Error while executing:

MERGE INTO TEST DEST
ON (DEST.CODE=SRC.CODE)
WHEN NOT MATCHED THEN
INSERT INTO TEST(CODE,DESCCRIPTION)
SELECT CODE,DESCRIPTION FROM TEST1

ORA-00926: missing VALUES keyword

Any help will be needful for me
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2009
Added on Aug 26 2009
2 comments
5,345 views