Oracle database

I have different spreadsheets in excel file. in the excel file there are months, bot need to enter the data from January to December in oracle but it enter the data from November month and from January to October it enters the data at the end of the to resolve this?

Hi @Cuberoot,

Just sort the data in datatable before inserting to oracle. Once data is sorted insert the data table in oracle


First filter with date later than november and fill it then get the remaining rows and add them again


data is already sorted in an Excel file