| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> SQL*Loader question- Transforming Data
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>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”.<span
style="mso-spacerun: yes"> Can I use a SQL statement in the SQL*Loader
control file to filter out those transactions?<span style="mso-spacerun:
yes"> Something that functions like this pseudocode:
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>if field like ‘%FLAG_TEXT%’ then null;
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>else load;
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>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.
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Thanks,
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<span
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail
Signature" <font
color=blue face=Arial><span style='font-family:Arial;color:blue;font-weight:
bold'>David B. Wagoner
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
font-style:italic'>Database Administrator<font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext;font-style:italic'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
font-weight:bold'>Arsenal Digital Solutions Worldwide Inc.<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-weight:bold'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>4815 Emperor
Blvd., Suite 110<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Durham, NC
27703<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;mso-color-alt:
windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Tel. (919)
941-4645<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Fax (919)
474-0695<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Email <a
href="mailto:dwagoner_at_arsenaldigital.com"><span
style='font-size:12.0pt;font-family:"Times New Roman"'>mailto:dwagoner_at_arsenaldigital.com<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Web <a
href="http://www.arsenaldigital.com/"><span
style='font-size:12.0pt;font-family:"Times New Roman"'>http://www.arsenaldigital.com/<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<span style='font-size:
8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'><span
style="mso-spacerun:
yes">*** NOTICE<span
<span style='font-size:
8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>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.<font
size=1 color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<font
color=black> <font
color=black>
Received on Mon Jul 30 2001 - 13:37:51 CDT
 |
 |