With below code I am able to insert multiple Records in H2 Database.
But with Oracle this doesn’t work.
Is there any other way to use normal SQL to INSERT multiple statements like that.
<code> //INSERT RECORDS
String sql = "INSERT INTO PERSON (NAME, AGE) VALUES ('"+name+"',+"+age+");" +
"INSERT INTO PERSON (NAME, AGE) VALUES ('Susan' ,20 )";
Statement statement = connection.createStatement();
int success = statement.executeUpdate(sql);
</code>
<code> //INSERT RECORDS
String sql = "INSERT INTO PERSON (NAME, AGE) VALUES ('"+name+"',+"+age+");" +
"INSERT INTO PERSON (NAME, AGE) VALUES ('Susan' ,20 )";
Statement statement = connection.createStatement();
int success = statement.executeUpdate(sql);
</code>
//INSERT RECORDS
String sql = "INSERT INTO PERSON (NAME, AGE) VALUES ('"+name+"',+"+age+");" +
"INSERT INTO PERSON (NAME, AGE) VALUES ('Susan' ,20 )";
Statement statement = connection.createStatement();
int success = statement.executeUpdate(sql);