I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience.
My question: Can I create a variable in TOAD/SQL to prompt for a date(s)? Here is what I want to do:
Question 1: Enter Beginning Date (user to enter date value that looks like this: 01/01/2015)
Question 2: Enter Ending Date (user to enter ending date value, i.e. 04/30/2015)
I then will need to create two further variables based on these first two to represent the prior years dates (i.e 01/01/2014 and 04/30/2014). I would know how to do this in VB.net. Unfortunately I'm not sure about PL/SQL (or whatever it is that TOAD uses). Can you teach me how to do this?
Thanks for your assistance.