title: Why does my query produce error "ORA-00933: SQL command not properly ended"?
body: <p>My query:</p>
  
  <pre><code>CREATE VIEW cambiodatos AS 
  SELECT 
      a.last_name||','||a.first_name AS "Nombre", 
      a.salary AS "Salario", 
      b.name AS "Nombre Departamento", 
      c.name AS "Nombre de Region"
  FROM 
      s_emp a, s_dept b, s_region c
  WHERE 
      a.dept_id = b.id AND b.region_id = c.id
  
  UPDATE 
       cambiodatos 
  SET 
       name = 'North America'
  WHERE 
       last_name = 'Biri'||','||first_name = 'Ben'
  </code></pre>
  
  <p>The error:</p>
  
  <pre><code>ORA-00933: SQL command not properly ended
  </code></pre>