Ampersands and application "chrome"

[Worker]

If you execute this query in a SQL window:

select 1 as "R&&D" from dual

the results window shows a column header of "RD" and the window list shows a single ampersand instead of two.

Perhaps I should have expected the single ampersand in the window list, but the column header is odd. That said, I know why it happens, I see it all over other Windows apps as well, and it doesn't bother me at all. Just reporting something you may want to fix.

 

[Marco Kalter]

By default the & precedes a substitution variable. By using && you can escape this, and the result will be a single &. To get R&&D as a result, you will need to specify R&&&&D.