5.5.4 : variable substitution with terminator suffix "."


def YEAR=2008

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’
def YEAR=2008

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.

Thank you.


Thanks for your feedback. It is a bug in 5.5 and it will be fixed in the next release.