In a Set Variable action, I cannot seem to use an expression as ‘value’. In Toad for Data Analysts, you can use e.g.
SELECT TO_CHAR(SYSDATE-1,‘DDMMYY’) FROM DUAL
and get the result of the expression into the value in a Set_Variable activity.
However, if you do that in Toad Automation Designer, the value becomes the select statement as a string. Reducing it just to the TO_CHAR() bit has a similar effect. I can’t get the result from the expression into the variable value. I can use a single system variable (e.g. %SYSDATE%), but other expressions don’t seem to work. Any thoughts?