Re: Using functions in SQL*loader

Jure Vehovec <Jure.Vehovec_at_factorb.si> writes:

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

You can use SQL functions that return single value results in the control file. Append the function ot the end of the line, seperated in double quotes, and make reference to the column value by preceding it with a colon. I.E:

<snip>

is_current CHAR	"DECODE(RTRIM(LTRIM(UPPER(:is_current))),
		    'TRUE', 'T', 
		    'FALSE', 'F', 
		    NULL)",
wire_gauge CHAR	"RTRIM(LTRIM(:wire_gauge))",