Home » Developer & Programmer » Data Integration » Upsert Problem
Upsert Problem [message #93188] Wed, 16 July 2003 09:44
Mark Goldberg
Messages: 4
Registered: July 2003
Junior Member
I'm trying to take advantage of Oracle 9i's
new Upsert feature, in which I use the Merge
statement to update or insert a record
from a transaction table into the master table.
I've gone over my SQL with a fine toothed comb,
and still keep getting the following error message:

ERROR at line 1:
ORA-00913: too many values

thanks.

Report message to a moderator

Previous Topic: name of foreign key
Next Topic: Urgent, BO - Query Prompt
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 20:51:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.