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

SQL-LOADER:Loading TAB Delimited DATA

Loading TAB Delimited DATA

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