Re: Using functions in SQL*loader

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/09/17
Message-ID: <342037a0.2136532@www.sigov.si>#1/1

On Wed, 17 Sep 1997 11:53:46 +0200, Jure Vehovec <Jure.Vehovec_at_factorb.si> wrote:

>Is it possible tu use SQL functions in SQL*loader.

Sure it is possible, dating back to SQL*Loader release 1.1 (shipped with later versions of Oracle 6.0). You can use functions on fields with so-called "SQL strings" - you can use most of the built_in functions as well as your own database functions. You apply a function on a field by enclosing the expression in double quotes, putting it after the field specification (position, datatype, field condittions).

>
>For example TRANSLATE.

e.g.:
.... col_x POSITION (1:5) CHAR "TRANSLATE (:col_x,'1234','ABCD')"

>
>jure vehovec
>jure.vehovec_at_factorb.si

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Sep 17 1997 - 00:00:00 CDT