Question: how to export data from oracle to excel automatically?
Answer: Go to automation designer.
drop in an “Export dataset” action.
double-click the new action and set whatever export options you want.
On the “Dataset” tab, enter your query. Click “Apply” and then close the dialog.
You can rt-click to schedule the action, or run it from command line with -a and the name of the action.