• Oracle

    Oracle SQL Loader DB link-21

    SQL Loader It’s a utility. It will load the external data table into oracle. Like excel, Csv & notepad. Keyword: sqlldr Syntax:  $ sqlldr un/pw parameter 1,2, etc .. Parameters: Control= <controlfile name> Inline = <input file name> Badfile= <badfile name> – it will have an unloaded data, incase of any failure and mismatch Discardfile=< discordfile  name> – It will store the  condition of the data. Like eno should be 3 digit Log =<logfile name> – log Ex: We have an employee  table ENo: 101,102,103ABC & 05 etc… SO the tow digit will not upload, since we have a condition and character will not upload and it will go to…