Disable Oracle 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!