I have experience running SQL on an Oracle DW using Toad at my previous job. I'm looking for an easy to use (and preferably free) solution where I can just import some csv files and play around with the data via running some SQL scripts. Any recommendations would be greatly appreciated.
Import into what kind of database? You don't say. (SQL is a language, not a database...)
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
Most of the free tools do not allow import from csv in the free version. But I'm sure you can achieve the same with SQL scripting. I think dbvis allows you to run random sql on any backend, but I dont know about import.
I just couldn't resist plugging our product which does what you asked for in a very different manner (check my signature for more info)