Re: Using functions in SQL*loader

From: Francisco Carlos Piragibe de Almeida <piragibe_at_esquadro.com.br>
Date: 1997/09/22
Message-ID: <01bcc73d$7314b280$6d55ffc8@vleda>#1/1

Yes, it is, though in a limited fashion. You can specify almost any valid ORACLE single row expression and apply it to a column before posting the record to the database. Here's an example:

col1 position (10:20) integer external ":col1/100+LEAST(:col1,230)"

Make sure the expression is enclosed by double quotes (Yes! Double quotes).

-- 
Francisco Carlos Piragibe de Almeida
consultant
ORACLE products and WEB applications

Jure Vehovec <Jure.Vehovec_at_factorb.si> escreveu no artigo
<341FA8AA.2F49_at_factorb.si>...


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

> 

> For example TRANSLATE.

> 

> jure vehovec

> jure.vehovec_at_factorb.si

>

Received on Mon Sep 22 1997 - 00:00:00 CDT