Re: External table field options

On Sun, 29 May 2005 22:28:29 +0300, Kirmo Uusitalo <kkklll_at_luukku.com.invalid> wrote:

>-I would like to extract the streetname from the streetaddress field
>in the csv file above so that everything starting from the first
>number after position 5 would be located in the streetno field.
>This should be possible, but as I'm not too familiar with sql*loader
>rather complex control file syntax.

I think the unfamaliarity would be addressed by reading it up, and trying to understand it. If you define an addrescode field as 'char' would you expect Oracle strips the leading zeroes? Also what you propose above is simply not possible: if you manage to concatenate individual columns together, there is nothing that can parse it, as such parsing will never be fool proof.

--
Sybrand Bakker, Senior Oracle DBA