Explain how to start a new transaction in Oracle.
An oracle transaction is a set of SQL statements written to perform a task. A transaction begins with the first SQL statement and ends when COMMITTED or ROLLED BACK.
Example:update emp_salary
set salary = salary + 1500
where
employee_no = 145';
commit;
Explain how to start a new transaction in Oracle.
Oracle server implicitly starts a new transaction with the following two conditions:
- The first executable statement of a new user session automatically starts a new transaction.
- After a transaction has ended, the next executable statement then starts a new transaction.
There is no SQL statement to explicitly start a new transaction.
