[오라클/SQL] Transaction - COMMIT/ROLLBACK (예제)

Transaction 

select department_id, department_name from departments
where rownum <=5;

insert into departments (department_id, department_name) values ('1000', 'IT_EDU');  -- 레코드추가

select department_id, department_name from departments
where department_id = 1000;

다른 콘솔에서 추가한 레코드를 볼 수 없다.

commit ;

 

ROLLBACK;