0

I am using Oracle SQL developer and stuck in the following part of my query

   WHERE table.books IN ('Jekyll & Hyde','Power')

The ampersand in "Jekyll & Hyde" is causing a window asking to enter a value, how can I fix the syntax so that it recognizes this as one of the titles I am looking to filter by.

looking to retrieve readers that have read certain titles, but the query is not executing in its current state

MT0
  • 143,790
  • 11
  • 59
  • 117
user18709081
  • 15
  • 5
  • Asked and answered: https://stackoverflow.com/questions/12961215/escaping-ampersand-character-in-sql-string – xQbert Nov 28 '22 at 22:34

1 Answers1

0

Execute

SET DEFINE OFF

before running the query; it'll instruct SQL Developer not to ask for a value of the substitution variable.

Littlefoot
  • 131,892
  • 15
  • 35
  • 57