User's current script uses the below code. Toad does not execute the Select statement using the value of DEFINE command:
DEFINE &&CURRENT_MONTH = '210906';
select * FROM tablename WHERE columname= '&&CURRENT_MONTH';
Modify script to resemble the below code and execute with F5 or 'Execute as Script' option:
DEFINE CURRENT_MONTH = '210906';
Select * FROM tablename WHERE columnname= '&CURRENT_MONTH';
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center