Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> merge command ???

merge command ???

From: Janet Linsy <janetlinsy_at_yahoo.com>
Date: Wed, 28 Jan 2004 08:54:27 -0800
Message-ID: <F001.005DE4A0.20040128085427@fatcity.com>


Hi, for Merge command, how to specify if matched, not to do anything, I tried NULL, not working. Thank you!

MERGE INTO caption c3
 USING caption_at_gtd1 c1
 ON (c3.caption_id = c1.caption_id)
WHEN MATCHED THEN
        NULL -- don't need to do anything when matched!  WHEN NOT MATCHED THEN
 INSERT (c3.CAPTION_ID,

        c3.CAPTION_NAME, 
        c3.VISIBILITY_ID, 
        c3.MOD_DATE, 
        c3.MOD_USER) 
 VALUES (c1.CAPTION_ID, 
        c1.CAPTION_NAME, 
        c1.VISIBILITY_ID, 
        c1.MOD_DATE, 
        c1.MOD_USER); 

__________________________________

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Janet Linsy
  INET: janetlinsy_at_yahoo.com
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 28 2004 - 10:54:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US