| |
GeekInterview.com > Interview Questions > Oracle
| Print | |
Question: Identify DML Error
Answer: MERGE INTO SAS F
USING (SELECT PRODID, PRODID+10 F, DESCRIP FROM
PRODUCT) L
ON (F.PRODID=L.PRODID)
WHEN MATCHED THEN
UPDATE SET F.PRODID=L.F
WHEN NOT MATCHED THEN
INSERT VALUES (L.F, L.DESCRIP)
Why does the above give error? |
| August 08, 2009 01:56:04 |
#1 |
| Lakshmi84 |
Member Since: July 2009 Total Comments: 4 |
RE: Identify DML Error
|
I think Error lies in the following statement
INSERT VALUES (L.F, L.DESCRIP)
THE STATEMENT SHOULD BE LIKE THIS
INSERT (F.PRODID,F.DESCRIP)
VALUES(L.F,L.DESCRIP)
|
| |
Back To Question | |
