RE: ** default in sql loader
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jul 2004 13:44:04 -0400
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@xxxxxxxxx]
Sent: Wednesday, July 28, 2004 1:39 PM
To: oracle-l@xxxxxxxxxxxxx
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
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
