Import CSV file to oracle DB

Question

Is there a simple Java library or approach that will take a SQL query and load data in a CSV file to oracle database. Pls help

Answer 1

You don't have to use Java to load a data file into a table unless it is absolutely necessary. Instead, I'd recommend Oracle's command-line SQL*Loader utility which was designed specially for this purpose.