1.

Solve : Putting a DEFAULT value in control file?

Answer»

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'
)


Discussion

No Comment Found

Related InterviewSolutions