Oracle External Tables – Part 1

If Only I Could Write A SQL Query On Data in a File…

Imagine you have a text file with data in, such as a CSV (character separated values) or ASCII fixed width fields, wouldn’t it be great if you could treat it like a table and write SQL queries against in? ¬†Well you can and that’s exactly what Oracle’s External Tables functionality allow you to do!
Read more…

Advertisements