Using Transactions in Oracle -
The first order executed during T1 select is a transaction, in return, delete Command (on time T2) The first order transaction is B. What will be the result of the SELECT statement at the time of T3 (a transaction)? In the T3, the SELECT statement will return a line (because transaction B is not committed yet)? Yes, it will be, as other transactions have not yet been done. If you try to do the same, then transaction B after transaction A in delete / Code>, then you have to wait for the lock to continue, but a SELECT will work fine.