Re: SQL*Loader: loading empty strings ?

mikebrearton_at_my-deja.com wrote:
>
> How can I load an empty string into a column?
>
> Loader replaces "" with NULL. They aren't the same, and I want "" not
> NULL.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Yes they are the same - in Oracle. Mind you, that is not consistent with the ANSI/ISO standard, but for better or worse an empty string is considered to be a null in Oracle. Received on Mon Jul 10 2000 - 00:00:00 CDT