Re: External Tables (Trimming Data)

Mark,

I use substr quite a bit in the transformations. I was hoping there was a way to trim the data in the external table definition so that I wouldn't have to set the datatype for the column in the external table to something arbitrarily large (varchar2(4000)). I want to set the length of the datatype to my setting and have the loader trim the string when necessary. Now, if there was a way to use substr in the external table definition like we could with sql loader, that would be great.

Thanks for the reply but still hoping for a solution. Received on Sat Jan 28 2006 - 20:07:46 CST