Hi, I am new to Oracle, and can't find the answer for this anywhere.
I have a giant SELECT query for a data extract that includes many subqueries.
I would like to limit the data being queried to a particular date range, and I need to do this in at least 30 different date ranges in my select query (to improve processing time) - so basically my query would call the two variables in 30 different places.
In SQL Server, I would've just created a stored procedure with the two variables, and executed it, putting the variable values in my EXEC statement.
I just need to be able to output the data to a spreadsheet or text file, and I'm looking for the easiest way to do this.
What tools does Oracle have that I can use for this, and what specific syntax would I need to use?
Thanks