title: When or Why to use a "SET DEFINE OFF" in Oracle Database
body: <p>I'm watching a Script in Oracle and I see something I don't recognize</p>
  
  <pre><code>REM INSERTING into database1."Users"
   SET DEFINE OFF;
  Insert into database1."Users" ("id","right") values ('1','R');
  </code></pre>
  
  <p>I'm looking for documentation about "set define off" and it's literally writing "disable the parsing of commands to replace substitution variable with their values"</p>
  
  <p>I don't really understand what they want to say.</p>
  
  <p>Can anyone help me?</p>