Re: SQL*Loader Control File

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 21 Jun 2005 13:11:38 -0700
Message-ID: <1119384697.989632.132740_at_g49g2000cwa.googlegroups.com>

The Loader only allows one set of characters to be defined.

You might be able to do something by "Applying SQL Operators to Fields"

If the addresses ALWAYS have enclosing characters, you might get away with a simple SUBSTR() operator. Or if the enclosing characters are always differrent from the legal characters of a email address (maybe not a bad assumption), you might just TRANSLATE() them away.

HTH,
Ed Received on Tue Jun 21 2005 - 22:11:38 CEST

This message: [ Message body ]
Next message: Malcolm Dew-Jones: "Re: Using a bind variable in an ACCEPT command PROMPT"
Previous message: McCormick: "Using a bind variable in an ACCEPT command PROMPT"
In reply to: rss_vishnu_at_yahoo.com: "SQL*Loader Control File"
Next in thread: Arto Viitanen: "Re: SQL*Loader Control File"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message