The update actually should be rollback in the transaction, however, it is commit in another transaction. Then I add a select after the update, and rollback the transaction, this time it is really rollback!! What going on? Please help! I am using Oracle.
Below capture the system flow (In the same session):