Home » RDBMS Server » Server Utilities » Re: Sql-Loader Date Format
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.
Previous Topic: Re: Cannot open database
Next Topic: Re: How does one export an Oracle table to a Comma Delimited Flat File
Goto Forum:
  


Current Time: Thu Mar 28 05:25:18 CDT 2024