SQL in Oracle(LiveSQL)

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65884249/sql-in-oraclelivesql

Answer 1

Another option is to use INSERT ALL:

insert all
  into students (sr_no, name, class, sec, contact, total_marks) values (1, 'Ravi' , 10, 'A', 12345, 579)
  into students (sr_no, name, class, sec, contact, total_marks) values (2, 'Ria'  , 10, 'B', 98765, 580)
  into students (sr_no, name, class, sec, contact, total_marks) values (3, 'Aditi', 10, 'A', 98498, 570)
select * From dual;