title: Oracle SQL - Update query with NOT EXISTS does not work
body: <p>I think I am going wrong with Oracle SQL syntax. This is the syntax I use in Transact-SQL. </p>
  
  <pre><code>UPDATE "DE_OPS"
  SET IMPORT_DATE = GETDATE()
  WHERE PROCEDURE_CODE NOT IN ( SELECT DISTINCT PROCEDURE_CODE FROM DE_OPS_20140730 );
  </code></pre>
  
  <p>I reframed this for Oracle SQL as </p>
  
  <pre><code>UPDATE "DE_OPS"
   SET IMPORT_DATE = SYSDATE()
  WHERE PROCEDURE_CODE NOT EXISTS ( SELECT DISTINCT PROCEDURE_CODE FROM DE_OPS_20140730);
  </code></pre>
  
  <p>But this gives the error </p>
  
  <p>Error at Command Line : 3 Column : 26
  Error report -
  SQL Error: ORA-00933: SQL command not properly ended
  00933. 00000 -  "SQL command not properly ended"
  *Cause:<br>
  *Action:</p>
  
  <p>Not sure where I am going wrong. Does "not exists" allow subqueries?</p>