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';
You need to be signed in and under a current maintenance contract to view premium knowledge articles.