text files - LOAD DATA INFILE equivalent in Oracle

Question

I just was wodering if there's an equivalent to MySQL LOAD DATA INFILE statemnent in Oracle? I need it because I want to read from a huge textfile into a database table.

Answer 1

Oracle gives the SQLLoader commandline utility. But it relies on a proper formatting of the data file.

You can try to look at Oracle External Tables (e.g. you can link a csv file as an external table and see it as a table within Oracle).

Both solutions have pros and cons, but the big cons is that they still rely on data input format (so if you have a file ready for mysql, you may need to tweak it a bit).