Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using functions in SQL*loader

Re: Using functions in SQL*loader

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: 1997/09/17
Message-ID: <3420A1FE.525B@ntsource.com>#1/1

One way to use functions is as follows

   val position(1:1) char "translate(:val, '1', '9')"

This would insert into column val a '9' whenever the input was '1'.

Jure Vehovec wrote:
>
> Is it possible tu use SQL functions in SQL*loader.
>
> For example TRANSLATE.
>
> jure vehovec
> jure.vehovec_at_factorb.si
 

-- 
Frank Hubeny            
fhubeny_at_ntsource.com            
Wheaton, IL 60187
Received on Wed Sep 17 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US