This is not possible. You will be prompted for all sub vars. You could use advanced template and replace &&FilePrefix with and before invoking the template copy your file prefix to clipboard. Not ideal, but as close as you can get I think.
On Dec 21, 2015, at 1:14 PM, chazamania firstname.lastname@example.org wrote:
Variables in Code Templates
Thread created by chazamania
Is there a way to optionally escape the & with an Advanced Template? In the sample below I want the prompt for &&FilePrefix. I want the SPOOL ‘&logname’ to remain as-is. I can put the &logname back in the prompt, but I’d prefer to have it automated and bullet proof.
SET VERIFY OFF
COLUMN clogname NEW_VALUE logname NOPRINT
SELECT SYS_CONTEXT (‘USERENV’, ‘INSTANCE_NAME’)
|| TO_CHAR (SYSTIMESTAMP, 'yyyymmddhh24miss')
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.