title: ORA-00933: SQL command not properly ended oracle database
body: <p>The following query run success with SQL Server Express 12 database, but It will throw an error with oracle database: </p>
  
  <blockquote>
    <p>ORA-00933: SQL command not properly ended</p>
  </blockquote>
  
  <pre><code>UPDATE ENTITY SET REQUIREDRESOLUTION = 0.005
  FROM ENTITY INNER JOIN FUNC ON ENTITY.FUNCCODE = FUNC.FUNCCODE 
  WHERE  (FUNC.TEMPLATE = 4) AND ((ENTITY.CATEGORYCODE = - 5) OR (ENTITY.CATEGORYCODE = - 7)) 
  </code></pre>
  
  <p>Could anyone help? How can I modified this query to able to use for both the SQL Server and Oracle database?</p>