title: How to run multiple statements in one sqlscript for Oracle
body: <p>I'm trying to run a few statements in one sql file but it does not work.</p>
  
  <pre><code>declare 
    new_sequence INTEGER;
  begin 
    select LAST_NUMBER + 1 
      into new_sequence 
      from user_sequences 
     where SEQUENCE_NAME = 'MLTS_SEQUENCE';
  
    execute immediate 'Create sequence Table_SEQ start with '
        || new_sequence ||' increment by 1';
  end;
  </code></pre>
  
  <p>If i run this block with the option 'execute as one statement' in the eclipse database plugin it works. </p>
  
  <p>How can i mark the sqlscript to run each of these blocks as one statement, to execute the script later with sqlplus or something different than eclipse?</p>
  
  <p>I tried GO in front and / at the end but that also didn't work.</p>