How to properly configure & character in SQL Developer 17.3

Question

Hello friends I am trying to make a sql query in SQL Developer as follows:

SELECT * FROM CLIENTE WHERE NOME_CLIENTE IN ('SALES & CIA AGUIAR', 'SAO JOAO')

The tool is understanding the character '&' as a variable input and thus does not display the record of that client, I wonder if there is any way to configure this so that when the character '&' is passed inside simple quotes the tool understands that it is a text.

Answer 1

Run this command before:

SET DEFINE OFF

And perform normally.

Or rewrite your command like this:

SELECT * FROM CLIENTE WHERE NOME_CLIENTE IN 
  ('SALES ' || chr(38) || ' CIA AGUIAR', 'SAO JOAO')