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.