Re: sqlldr to

From: <Diana_Duncan_at_ttpartners.com>
Date: Tue, 22 May 2001 05:40:54 -0700
Message-ID: <F001.0030A786.20010522052133@fatcity.com>

Example of a SQL*Load control file to load a file, skipping the first line, replacing the data in the table, with comma-separated, double-quote enclosed data, using the decode function on one of the columns.

OPTIONS (SKIP=1)
LOAD DATA
INFILE "data.dat"
INTO TABLE mytable REPLACE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (
REC_TYPE char,
VCID char,
SHIP_TO_ID char "decode(:SHIP_TO_ID, '?', '0')" )

Maybe this is what you're looking for?

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: Diana_Duncan_at_ttpartners.com

                                                                                       
                            
                    Roland.Skoldb                                                      
                            
                    lom_at_ica.se           To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    Sent by:             cc:                                           
                            
                    root_at_fatcity.        Fax to:                                       
                            
                    com                  Subject:     sqlldr to_number                 
                            
                                                                                       
                            
                                                                                       
                            
                    05/22/2001                                                         
                            
                    03:00 AM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L

Hallo you DBA's:

How can I write a script in ctl-file if I want to import a textfile. I want to use the command decode because I want to replace the character '?' with a 0 (zero), which is a number field inthe database. How can I do this. I want to do it while the sqlldrscript is running.

Sincerely

Roland Sköldblom

--

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

Author:
INET: Roland.Skoldblom_at_ica.se

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: Diana_Duncan_at_ttpartners.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

Re: sqlldr to_number