sql window: dot (".") should end substition variable

[Bernhard S]

Hello,

the dot currently does not end a substition variable in the sql window.
I issue the following sql:

select 'prod&reg._dba.my_table' test from dual;

In SQL Window I get asked and enter:
Name Value
reg 01

Result is: prod01._dba.my_table
(note the dot after 01 here!)

In Command Window I get asked:
Enter value for reg:
and I enter again: 01

Result is: prod01_dba.my_table
(no dot after 01 here!)

In SQL*Plus behaviour is the same as in Command Window.
I think, behaviour in SQL Window should be adapted and dot should end substition variable, but also not be shown in result value.

Regards,
Berny

 

[Marco Kalter]

The substitution variables in the SQL Window are different (and more powerful) than in SQL*Plus or in the Command Window. See chapter 10.3 in the User's Guide for more details.

The equivalent in the SQL Window is:

select 'prod&_dba.my_table' test from dual;

 

[Bernhard S]

Thank you for your answer. That solves my problem.
Didn't think about checking the "Reports" section regarding this issue, even though that's already mentioned in chapter 6.3 too.

Berny