sql loader grammar

$ sqlldr userid=myusername@mydatabase/mypassword control=mytable.ctl log=mytable.log

$ cat mytable.ctl

load data
infile ‘mytable.dat’
badfile ‘mytable.bad’
append
into table est_compare
fields terminated by X’09’ — tab delimiter
TRAILING NULLCOLS
(
mycolumn1,
mycolumn2
)

Leave a Reply