INSERT SOME ROWS AND COMMIT THEM

3. Insert some rows and commit them:

insert into tmp_emps select * from employees where department_id=30;

commit;