Disable Oracle substitution parsing I need to update a string (VARCHAR2) value in an Oracle database which contains Javascript code.

The update script contains the following string:

c===l&amp;&amp;p(a,b)


which when executed from "Oracle SQL Developer", triggers (on that line) the following popup:


Is there a way to disable the substitution parsing?
You can use this command to disable parsing for substitution variables for the session.  

SET DEFINE OFF;


Enter this at the start of the query or operation.  This cannot be used with PL/SQL code blocks but the standard SELECT, INSERT, UPDATE, DELETE allow it.

This Stack Overflow question from 2010 shows this is a popular question!