title: Perl DBI - run SQL Script with multiple statements
body: <p>I have a sql file  <strong>test.sql</strong> used to run some SQL  (create object / update / delete / insert) that can look like this</p>
  
  <pre><code>    CREATE TABLE test_dbi1 (
      test_dbi_intr_no    NUMBER(15)
    , test_dbi_name       VARCHAR2(100);
  
  UPDATE mytable 
  SET col1=1;
  
      CREATE TABLE test_dbi2 (
      test_dbi_intr_no    NUMBER(15)
    , test_dbi_name       VARCHAR2(100);
  </code></pre>
  
  <p>Usually, i would just use SQLPLUS (from within Perl) to execute this test.sql using this command :
  @test.sql</p>
  
  <p>Is there a way to do the same thing, using DBI in Perl ?
  So far, i found DBI can only execute one statement at a time, and without the ";" at the end.</p>