'&variable_name' i.e. '&date1' '&date2' should prompt for input.
This has nothing to do with Toad as Toad us just an I.D.E.
It has everything to do with Oracle sql, *sqlplus, PL/Sql.
Hope this helps
On May 19, 2017 1:29 AM, "hrishi14" email@example.com wrote:
Thread created by hrishi14
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.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Code Tester for Oracle Forum notifications altogether.
Code Tester for Oracle - Discussion Forum
Flag this post as spam/abuse.