Re: Sql-Loader Date Format [message #367974] |
Wed, 11 August 1999 05:05 |
Lars O Sjöström
Messages: 25 Registered: May 1999
|
Junior Member |
|
|
You have to specifiy another parameter as well, that will ignore blanks. I think that is possible.
Or use the column_name NULLIF column_name = BLANKS, that is also, and maybe better solution.
There can be also a possibility to use DECODE in this case, but that could be tricky. Since you might not know how many blanks there are in the field. But DECODE(SUBSTR(col_name,1,1),' '),'19990101') could work as well.
|
|
|