$ sqlldr userid=myusername@mydatabase\/mypassword control=mytable.ctl log=mytable.log<\/p>\n
$ cat mytable.ctl<\/p>\n
load data
\ninfile ‘mytable.dat’
\nbadfile ‘mytable.bad’
\nappend
\ninto table est_compare
\nfields terminated by X’09’ — tab delimiter
\nTRAILING NULLCOLS
\n(
\nmycolumn1,
\nmycolumn2
\n)<\/p>\n","protected":false},"excerpt":{"rendered":"
$ 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 )<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/www.hongyu.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/95"}],"collection":[{"href":"https:\/\/www.hongyu.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongyu.org\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongyu.org\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongyu.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=95"}],"version-history":[{"count":0,"href":"https:\/\/www.hongyu.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/95\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hongyu.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongyu.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongyu.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}