My manager has asked me to write a program that pulls data from a database that I have access to (it's an Oracle database and I'm using SQL developer). The idea is to get the data they want and put into an excel sheet in a way they would like. I haven't really wrote scripts before nor have I ever wrote a scraper, I was wondering what the first step is here and what resources I should use to get started? I have a couple of weeks to do this but I don't really know where to start.
I would start with an SQL query to find the data your manager wants. If you got the right result on screen, just right-click into the query result, select 'Export', and format= Excel...