title: How to insert multiple rows in the same table-Oracle 10g
body: <p>I created a table in <code>Oracle SQL</code> :</p>
  
  <pre><code>create table t1
   (
   empno number(6) PRIMARY KEY,
   empname varchar(30),
   hiredate date,
   basic number(8),
   deptno number(4)
  );
  </code></pre>
  
  <p>And now I am inserting values into the table using a <b>single query</b>:</p>
  
  <pre><code>insert into t1 values((131309,'HP','20-FEB-04',2000000,1235)
  (131310,'HT','20-APR-14',120020,1234));
  </code></pre>
  
  <p>But this shows error:</p>
  
  <pre><code>insert into t1 values((131309,'HP','20-FEB-04',2000000,1235),
                               *
  ERROR at line 1:
  ORA-00907: missing right parenthesis
  </code></pre>
  
  <p>How do I correct this? </p>