title: Why is this sql query giving syntax error?
body: <pre><code>begin transaction;
  update employee set id = id/10;
  update sales set employee_id = employee_id/10;
  commit;
  </code></pre>
  
  <p>The error message:</p>
  
  <pre><code>Error starting at line 1 in command:
  begin transaction;
  update employee set id = id/10;
  update sales set employee_id = employee_id/10;
  commit; 
  Error report:
  ORA-06550: line 4, column 8:
  PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
  
     ( begin case declare end exception exit for goto if loop mod
     null pragma raise return select update while with
     &lt;an identifier&gt; &lt;a double-quoted delimited-identifier&gt;
     &lt;a bind variable&gt; &lt;&lt; continue close current delete fetch lock
     insert open rollback savepoint set sql execute commit forall
     merge pipe purge
  06550. 00000 -  "line %s, column %s:\n%s"
  *Cause:    Usually a PL/SQL compilation error.
  *Action:
  </code></pre>