Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!diablo.voicenet.com!prodigy.com!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr28.news.prodigy.com.POSTED!not-for-mail From: "Randy Harris" Newsgroups: comp.databases.oracle.misc Subject: Adding changed records Lines: 8 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: <5iEta.4179$3f7.3486286@newssvr28.news.prodigy.com> NNTP-Posting-Host: 66.73.190.127 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr28.news.prodigy.com 1052184833 ST000 66.73.190.127 (Mon, 05 May 2003 20:33:53 CDT) NNTP-Posting-Date: Mon, 05 May 2003 20:33:53 CDT Organization: Prodigy Internet http://www.prodigy.com X-UserInfo1: OX]QBYWELBTQB_@[GZOD]V@APZXTPO\MAPVZKB]MPXHDUWYAKVUOPCW[ML\JXUCKVFDYZKBMSFX^OMSAFNTINTDDMVW[X\THOPXZRVOCJTUTPC\_JSBVX\KAOTBAJBVMZTYAKMNLDI_MFDSSOLXINH__FS^\WQGHGI^C@E[A_CF\AQLDQ\BTMPLDFNVUQ_VM Date: Tue, 06 May 2003 01:33:53 GMT Xref: core-easynews comp.databases.oracle.misc:97350 X-Received-Date: Mon, 05 May 2003 17:37:15 MST (news.easynews.com) Is there a simple means, with either SQL*Plus or SQL*Loader, to UPDATE records if they exist but INSERT if they do not? -- Randy Harris