Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

« previous next »
Pages: [1]   Go Down

Author Topic: Putting a DEFAULT value in control file  (Read 9617 times)

0 Members and 1 Guest are viewing this topic.

manas0603

    Topic Starter


    Newbie

    Putting a DEFAULT value in control file
    « 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'
    )
    Logged
    Pages: [1]   Go Up
    « previous next »