sqlplus - Getting String values from Oracle -

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';