| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ** default in sql loader
Joshi,
It is actually working as it is supposed to work. The default value is only included if the column is not used in the insert statement.
For Sql*Loader purposes, I would use a nvl function in the sql*loader control file to load the value you need. The control file would look something like:
Col_name terminated by "," "nvl(:Col_name,'YOUR VALUE')"
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: A Joshi [mailto:ajoshi977_at_yahoo.com]
Sent: Wednesday, July 28, 2004 1:39 PM
To: oracle-l_at_freelists.org
Subject: ** default in sql loader
Hi,
I have table and it has a field that has a default. I am loading the table
from sql*loader. When the field is null in data file I want it to put the
default. However it does not work. Even at sqlplus level if I insert a row
using insert into .... values... it only puts the default if the field is
not included. If the field is included in the list and a null is specified
then it does not put the default.
One way to overcome this is have a pre-insert trigger which checks for
null and then puts the default but I am avoiding that and also if the
default changes then I have to change the trigger.
MAybe I am missing something basic here. Can someone help. Thanks
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |