RE: SQL Loader questions (9i will let you do a merge)

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 24 Oct 2001 19:20:03 -0700
Message-ID: <F001.003B3BBA.20011024192518@fatcity.com>

For interest, 9i introduces the SQL Loader merge command which combines update and insert.

So if they were reading 9i doco then they might have been partly right.

Refer to Jonathan Gennick's article from Oracle Magazine - available online at http://www.oracle.com/oramag/oracle/01-sep/index.html?o51o9i.html (or the doco).

Regards,
Bruce Reardon

-----Original Message-----
Sent: Thursday, 25 October 2001 7:16

Thanks to all for reconfirming this for me. I had never heard of SQL Loader doing these things, but couldn't quite convince the programmer.

What I have since found out is that once upon a time, a consultant came in and set up the job that loads their data - and left without documenting it. Lo and behold, there's a lot of other stuff the script is doing besides running SQL Loader.

Thanks again for all your responses.
Lisa :D

-----Original Message-----
Sent: Wednesday, October 24, 2001 1:00 PM

what documentation has your programmer been reading?

as far as I know you can't add a column on the fly through a sqlloader control file, nor will oracle do an update to existing data.

I'm not an expert, but I've never been able to do that

• YTTRI Lisa <lisa.yttri_at_cnh.com> wrote:
  > Hi everyone -
  >
  > I need some help. We have an application running on 8.0.5 on NT. My
  > programmer tells me that she should be able to add columns to a table
  > simply
  > by changing the sql loader control file definition of the input. I
  > have
  > looked through the documentation and tried several tests, but I can't
  > see
  > any way that this would work.
  >
  > Is this actually possible with SQL Loader?
  >
  > Also, she tells me that if a record exists in the table and she has
  > the same
  > record (key value only) in the input file, that SQL Loader should
  > update the
  > record with any changed field values. Is there a special keyword to
  > do this
  > - I can't seem to find anything on that either?
  >
  > Thanks in advance for any help you can give me.
  >
  > Lisa
  > --
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Oct 24 2001 - 21:20:03 CDT