Re: SQL Loader Question

Hi Dennis,

as far as I know, you cannot justify data in an Oracle table (and my DBA agrees with me). If you want data to appear right justified in a Form, Report or SQL output file, you will have to arrange that in Forms, Reports or SQL*Plus.

<dennishancy_at_eaton.com> schreef in bericht news:8vgi9p$jo3$1_at_nnrp1.deja.com...
> My input data file includes a character field that needs to be right
> justified in my Oracle table. Naturally, the input data is left
> justified.
>
> Two thoughts have occurred to me as to how I can resolve this problem.
> Either I can pad the field in the input file with the appropriate number
> of blanks, or I can look for a solution in SQL Loader.
>
> I was hoping to do something like this in my CTL file:
>
> (lpad(COST,7) char,...
>
> But that didn't work.
>
> Any thoughts on what I can do in SQL Loader to accomplish this?
>
> Thanks.
>
>
> Dennis Hancy
> Eaton Corporation
> Cleveland, OH
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 24 2000 - 16:13:54 CET