Hi Team,
Greetings!
We have the requirement to load the multiple data files with high data volume in it for years to be uploaded into Oracle tables. The data also includes the non-English characters also.
The method we typically use it either import in TOAD or SQL Loader or external table option, but all of these need the table structure to be defined to store the data.
As the data is not structured i.e. does not have same set of columns in all tabs in the input files- is there any better and efficient way ( like loading the data from excel as is into tables and then using the positions from that to move into the required table or any other intelligent way) to handle this ?
Thanks,
Parag