| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Loader question- Transforming Data
Hello David,
You need to use the WHEN clause. Look at the example in the middle of page 147. If an input record doesn't match the conditions you specify following WHEN, it simply isn't loaded.
Best regards,
Jonathan Gennick
mailto:jonathan_at_gennick.com * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Monday, July 30, 2001, 2:56:22 PM, you wrote:
DW> I'm using SQL*Loader to populate a database table with transaction records. DW> The data file contains some transactions that I want to exclude from the DW> load and they all contain the same text string, something like DW> "xxx,yyy,FLAG_TEXT,xxx,yyy". Can I use a SQL statement in the SQL*Loader DW> control file to filter out those transactions? Something that functions DW> like this pseudocode:
DW> if field like '%FLAG_TEXT%' then null; DW> else load;
DW> I've been reading the new Oracle SQL*Loader book by Gennick and Mishra which DW> is a good book, but I'm still uncertain about this.
DW> Thanks,
DW> David B. Wagoner DW> Database Administrator DW> Arsenal Digital Solutions Worldwide Inc. DW> 4815 Emperor Blvd., Suite 110 DW> Durham, NC 27703 DW> Tel. (919) 941-4645 DW> Fax (919) 474-0695 DW> Email <mailto:dwagoner_at_arsenaldigital.com> DW> mailto:dwagoner_at_arsenaldigital.com DW> Web <http://www.arsenaldigital.com/> http://www.arsenaldigital.com/ DW> *** NOTICE *** DW> This e-mail message is confidential, intended only for the named DW> recipient(s) above and may contain information that is privileged, work DW> product or exempt from disclosure under applicable law. If you have DW> received this message in error, or are not the named recipient(s), pleaseDW> immediately notify the sender at (919) 941-4645 and delete this e-mail DW> message from your computer. Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: jonathan_at_gennick.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). Received on Mon Jul 30 2001 - 15:02:15 CDT
 |
 |