Question: how to load xls file into oracle table using sql loader?
Answer: Select Save As option and select CSV (Comma Delimited) format from Save As Type dropdown. Select Filename as persons. csv in c:\oracle folder. This will create persons. csv file that contains name and age sepearated by , (comma). You can open it with any text editor and check its contents.