Re: SQL Loader questions

You might ask your programmer to read the manual. However, the first might be a nice enhancement but it's not currently available.

As for the second, SQL*Loader either inserts into an empty table or appends to a table with existing data. It doesn't do an implicit update. However, if your table has a column with a timestamp showing when each row was inserted then you could disable the unique constraint, append the new data via SQL*Loader, find the rows with duplicate key values, delete the older rows and re-enable the constraint.                                                                                             

                    YTTRI Lisa                                                         
    
                    <lisa.yttri          To:     Multiple recipients of list ORACLE-L  
    
                    @cnh.com>            <ORACLE-L_at_fatcity.com>                        
    
                    Sent by: root        cc:                                           
    
                                         Subject:     SQL Loader questions             
    
                                                                                       
    
                    10/24/2001                                                         
    
                    12:05 PM                                                           
    
                    Please                                                             
    
                    respond to                                                         
    
                    ORACLE-L                                                           
    
                                                                                       
    
                                                                                       
    

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: YTTRI  Lisa
  INET: lisa.yttri_at_cnh.com

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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: tday6_at_csc.com

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).