Friday, May 4, 2012

SQL-LOADER:Loading TAB Delimited DATA which has null values

Loading TAB Delimited DATA which has null values

load data
infile *
append into table vnk_t11
fields terminated by X'09'
trailing nullcols
(
sno,
sname,
branch terminated by whitespace
)
BEGINDATA
1    nanikalyanvarasala    CSE
2        ECE
3    Johnny
4    Praveenkumar    EEE
    Bhadra    MECH

3 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. nice blog thanks for sharing such a beautiful information for more detsils click the below link
    click here

    ReplyDelete
  3. Workday HCM Online Training

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    ReplyDelete