I’m using SQL*Loader to populate a database table with transaction
records. The data file contains
some transactions that I want to exclude from the load and they all contain the
same text string, something like “xxx,yyy,FLAG_TEXT,xxx,yyy”. Can I use a SQL statement in the SQL*Loader
control file to filter out those transactions? Something that functions like this pseudocode: if field like ‘%FLAG_TEXT%’ then null; else load; I’ve been reading the new Oracle SQL*Loader book by Gennick and Mishra
which is a good book, but I’m still uncertain about this. Thanks, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor
Blvd., Suite 110 Durham, NC
27703 Tel. (919)
941-4645 Fax (919)
474-0695 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/
*** NOTICE *** This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, work product or exempt from disclosure
under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail message
from your computer. Thank you. |
- RE: SQL*Loader question- Transforming Data David Wagoner
- RE: SQL*Loader question- Transforming Data Mercadante, Thomas F
- Re: SQL*Loader question- Transforming Data Jonathan Gennick
- RE: SQL*Loader question- Transforming Data David Wagoner
- RE: SQL*Loader question- Transforming Data Kevin Lange
- Re[2]: SQL*Loader question- Transforming Data Jonathan Gennick
- Re: SQL*Loader question- Transforming Data Scott Canaan