I have a table in the Oracle database, in which ID is the name field.
This is the data:
123, 'South'
121, 'East'
445, 'Africa & amp; World '
When I select the rows where
choose name from where name =' Africa & amp;
Oracle asks for a replacement variable and no record returns.
Please ask me to clarify your question further.
Regards
The problem is that & amp; is reserved as a marker for the compulsive variables you have
& amp; Icons need to be avoided
You can avoid empires
capture SET; Choose from name where name = 'Africa' & amp; world'; Or you can set closed binding;
; * Choose from name * Name * 'Africa & amp; world';
Comments
Post a Comment