document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. -- template for sql loader control file
  2.  
  3. LOAD
  4. DATACHARACTERSET UTF8
  5. INFILE \'infile.txt\'
  6. BADFILE \'badfile.bad\'
  7. DISCARDFILE \'dscfile.dsc\'
  8. APPEND
  9. INTO TABLE MITABLA
  10. FIELDS TERMINATED BY X\'09\' OPTIONALLY ENCLOSED BY \'"\'
  11. (   FIELD1,
  12.     FIELD2 "TO_NUMBER(:FIELD2,\'99999.9999\')",
  13.     FIELD3 FILLER,
  14.     FIELD4,
  15.     FIELD5 FILLER)
');