I'm using SQL Developer 18.2 to connect to a MS SQL Server database. When running SQL to do inserts with data containing the '&' symbol, I need to use 'SET DEFINE OFF' to prevent the prompts for variable substitution. But when I include that in my SQL, I get the following error:
Error starting at line : 4 in command -
SET DEFINE OFF
Error report -
'DEFINE' is not a recognized SET option.
I can run "help set" and see "DEF[INE]" listed as an option and "help set define" to see the exact syntax, but the command itself does not work. How can I get this to work, or alternatively, turn off variable substitution by some other method?