The system ask me:
Please enter valuer for
but i have defined the variable YEAR beacuse i want work with it not with variable YEAR0207!!!
Studing the Oracle documentation about Oracle SQL syntax I have discovered that I can explicitly say to oracle when my variable terminate using the suffix “.”.
so that if i change my query in this way:
select** * from dual where to_char(sysdate,‘YYYYMMDD’)=’&&YEAR0207’
select * from dual where to_char(sysdate,‘YYYYMMDD’)=’&&YEAR.0207’
The system undertsand that i mean YEAR and not YEAR0207 variable
The problem is that In SQL Navigator it work but the system ask me the prompt of the YEAR variable, although I have used the && syntax.
I want notice that the same query in SQLPLUS shell not ask me the variable prompt just like I wanted.