0

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&&p(a,b)

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

Is there a way to disable the substitution parsing?

3

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!

  • 2
    It should be noted that this is a feature of SQL*Plus and is utilized by some graphical tools – Joe W May 22 at 16:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.