As example, if I run the following two statements to be prompted for variable values, I get re-prompted on each script. This of course gets old really fast. Is there some basic means to have the thing run end-to-end without re-prompting and without getting into the proprietary overhead of using the Automation bells and whistles?
select *
from SalesMonth{{Quote(:yyyymm)}} s
where s.saleamount>{{Quote(:min_sale_amt)}}
order by saleamount desc;
select *
from SalesMonth{{Quote(:yyyymm)}} s
where s.region={{Quote(:what_region)}}
order by saleamount desc;
There is a way to do this via the Bind Variable Store in the Toad Views panel (accessible by the Toad->Toad Views pull down menu). Assuming that it's ok to specify the bind variable values before script execution, hit the (x)= button at the top of the Toad Views menu and you can furnish your values there, per snap below.
If you need to be prompted at runtime, then you'll probably either need to use Automation, or declare your bind variables in a code block. Hope this helps.
Thx Gary. Only through your reply here did I unravel what the help text actually meant about how to make these values more stored/global.
When you say declare your bind variables in a code block, I know what you mean in general, though not specifically. So you maybe you mean... have PL/SQL upfront that just does a bunch of Declare statements... or something else?
Right, or an anonymous block that has your declares and var assignments...
See this helpful link (among many others) for further guidance.
