Computer Hope

Software => Computer software => Topic started by: manas0603 on February 11, 2009, 04:28:58 AM

Title: Putting a DEFAULT value in control file
Post by: manas0603 on February 11, 2009, 04:28:58 AM

Hi,
Is it possible to put some default values in a SQL*Loader control file?

Can i put like this?

LOAD DATA
Append INTO TABLE A
Fields terminated by ";"
TRAILING NULLCOLS
(
  ITEM              "upper(:ITEM)",
  QTY                DEFAULT 0,
  LOC                CONSTANT 'INDIA'
)