00927在oracle sql中缺少等号,但我正在显示所需的所有等号

shstlldc  于 2021-07-24  发布在  Java
关注(0)|答案(0)|浏览(257)

这是密码。我检查了好几次,但一切都正常。我可能还没找到等号,或者是别的原因?

MERGE INTO existing_customers c
USING new_customers n
ON (c.customer_id = n.customer_id)
WHEN MATCHED THEN
    UPDATE SET
    c.first_name = n.first_name,
    c.last_name = n.last_name,
    c.address_state = n.address_state,
    c.email_address = n.email_address,
WHEN NOT MATCHED THEN
    INSERT (c.customer_id,c.first_name,c.last_name,c.address_state,c.email_address)
    VALUES (n.customer_id,n.first_name,n.last_name,n.address_state,n.email_address)

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题