Just getting started with Toad - I'm trying to have a variable prompt ask for a phone number, query a table, then export the data to an excel spreadsheet
I have a query that works in the editor
select * from PHONE_EVENT_HISTORY where PHONE_NUMBER like '%&phone%';
but when I run it through the automation designer/export dataset it seems to not pick up on the variable I set with a variable prompt. Am I approaching this wrong?