Inserting Multiple Rows Into Table - Getting Error Ora-00933: Sql Command Not Properly Ended

create table employee ( employee_id number (5), first_name varchar2(100), last_name varchar2(100), salary number (10), department_id number(5), hire_date dat

Solution 1:

Wrong syntax.

Either

insertinto employee (employee_id, last_name, salary)
  values (129, 'khaj', 19000);
insertinto employee (employee_id, last_name, salary)
  values (130, 'ravi', 20000);

or

insertinto employee (employee_id, last_name, salary)
  select129, 'khaj', 19000from dual unionallselect130, 'ravi', 20000from dual;

or even

insertallinto employee (employee_id, last_name, salary) values (129, 'khaj', 19000)
  into employee (employee_id, last_name, salary) values (130, 'ravi', 20000)
select*from dual;