var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to query a field with a value containing a character "&"
When I make a simple query like:
select * from table1 where field1 = 'A&B'
Oracle asks me to enter a value for B.
How to query a field with a value containing a character "&"
It's not "Oracle" that asks you, but SQL*Plus.
You need to turn off parameter replacement using the command "SET DEFINE OFF"
More details are in the manual:
If it is not SQL*Plus you are using (but some other (GUI) tool, such as TOAD or similar), there might be a (right-click) option named "Prompt for substitution variables" - you'd have to uncheck it.
It is in SQL Nav.
Deselecting the "& Scan Defines" by right clicking the mouse in the query pane helps.
Thanks for your input.
The next time you should include this important piece of information right from the start...
Originally Posted by Wim Venema