I want to build a utility that can import data from excel sheet(columns are fixed but sheets can be any number) to oracle db. Can you suggest how should I:
- Read excel sheets(n number)?(Best way)
- Validate data?
- Bulk insert into DB?
My concern is performance here. Each sheet can have 200,000+ rows.
PS - please remember I am a complete newbie to oracle.