Home » RDBMS Server » Server Utilities » SQL Loader - Loading Default Values defined in database
SQL Loader - Loading Default Values defined in database [message #368433] Tue, 26 December 2000 10:22 Go to next message
Mike Oakes
Messages: 25
Registered: December 2000
Junior Member
Hello,
I am loading a flat data file through SQL Loader and for some columns the value = ''. When the data is loaded it is being loaded as NULL.

Is there a way to not assign these values to NULL. I do not want to store NULLS in the database. If possible I would Like the default value to be assigned into the field but this is not working.

Is there a sql string statement that I could use at the colunn level to assign a default value if it is NULL.

Thanks in advance for your help,
Mike Oakes
Re: SQL Loader - Loading Default Values defined in database [message #368435 is a reply to message #368433] Tue, 26 December 2000 13:42 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,
nvl(col1, default_val)

use this expression in you ctl file
to replace nulls with default_val for col1.

Bala.
Previous Topic: hot backup problem
Next Topic: Migration Interbase / Oracle
Goto Forum:
  


Current Time: Fri Mar 29 02:28:49 CDT 2024