title: 0 rows inserted - How can I fix this?
body: <p>I an trying to INSERT multiple rows into an SQL, Oracle table though SQL Developer v3.0.04</p>
  
  <p>the Database was set-up by Uni so I don't know what version it is.</p>
  
  <p>after looking on-line I have come up with the code below but it will not INSERT any data.  I have tested the insert with just one row and that is OK.  What am I missing?</p>
  
  <pre><code>Insert all 
    Into Patient Values
      ('101', '1 house', Null, 'Kingston', 'Surrey', 'KT1 1XX', '10/jan/1980', 'm', 01452987456)
    Into Patient Values
      ('102', '2 egg rd', 'vail', 'guildford', 'Surrey', 'GU1 1LL', '05/dec/1985', 'm', 01452987456)
    Into Patient Values
      ('103', '6 station rd', Null, 'guildford', 'Surrey', 'GU1 2XX', '15/may/1990', 'f', 01452987456)
  
  Select * from Patient;
  </code></pre>