How to correctly set the & character in SQL Developer 17.3

Navigation
0

Hello friends I'm trying to do a sql query in SQL Developer as follows: 

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

The tool understands the '&' character as a variable entry and so does not display the record of that client, I would like to know if there is any way to set this so that when the '&' character for passing within single quotes the tool understands that it is a text.

    
asked by anonymous 21.12.2017 / 12:00

1 answer

0

Run this command before: 

SET DEFINE OFF

And run normally.

Or rewrite your command like this: 

SELECT * FROM CLIENTE WHERE NOME_CLIENTE IN 
  ('SALES ' || chr(38) || ' CIA AGUIAR', 'SAO JOAO')
    
21.12.2017 / 13:17
Doubts about normalization of polynomials How to change the zoom in a certain location in google maps api v3?