Question: how to import data from xls to oracle table?
Answer: In Oracle sql developer go to Tables --> select import data ---> select your excel or csv file --> it will display the column --> import the data into a table.