Oracle SQL Developer or SQLPlus for creating a scheduled query
Posted on 2014-09-10
I have the pleasure of having to attempt to export a daily CSV file every night from a query in Oracle 12.1. I am struggling mightily at this as I have next to nothing in terms of experience with Oracle. I have an existing query that works great if I run it in SQL Developer and then manually export, but I have to schedule this. I have read bits and pieces about this being able to be done in sql developer. I have heard far more about sqlplus, but for the life of me I cannot figure out how to use this with my query. The syntax appears to be very different from what I did in straight SQL. Left Outer Join is apparently not a sqlplus option, or at least there is different syntax required for this.
What seems easiest to me is to simply save my query as a SQL file, which contains the spool command to create the CSV, and schedule that via a windows task, but need something to be able to run the SQL file.
Is this better suited for a newbie in SQL Manager or sqlplus or some other nice and nifty tool. I checked out Toad, but that appears to need to be purchased to get functionality I would need.
I am happy to explore other reporting tools, and I do have Crystal, but not the server so I dont think I can have it auto create the CSV.