Sql Loader In Oracle. When i added when statement, i got error: Loading objects, lobs, and collections with sql*loader.

Oracle instant client now includes sql*loader as well as the data pump command line utilities expdp and impdp, and the traditional export/import utilities exp and imp. Save your excel file in csv format, in my case, i have a test.csv file. Similarly other columns are also located.