gareth_moore
Member²
If I run SQL with variables, the result of the variable is stored in the recall statement not the variable itself.
A simple example to show this is as follows.
I ran the following SQL and put hello into the &test variable
SELECT '&test' test_text FROM dual;
In the recall statement I see:
SELECT 'hello' test_text FROM dual
Is it possible to have the option of storing the variable as opposed the the result of the variable in the recall statement?
A simple example to show this is as follows.
I ran the following SQL and put hello into the &test variable
SELECT '&test' test_text FROM dual;
In the recall statement I see:
SELECT 'hello' test_text FROM dual
Is it possible to have the option of storing the variable as opposed the the result of the variable in the recall statement?
