Re: SQL Loader Question

Dennis,

Try this:

(cost char "lpad(:cost,7)",...

Good luck:)

-- 
Regards,

Zbigniew Sliwa
Oracle Programmer
Poland
email: zibi_at_at_yahoo.com


dennishancy_at_eaton.com wrote:


> 

> 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.