Oracle rolling back transactions

SELECT CASE
           WHEN bitand(FLAG, power(2, 7)) > 0 THEN 'Rolling Back'
           ELSE 'Not Rolling Back'
       END AS "Rolling Back Status"
FROM V$TRANSACTION
WHERE ADDR IN (SELECT TADDR FROM V$SESSION WHERE USERNAME = 'USER_NAME');

Similar codes

0 vote198 views1 answer
Raiserror nowait sql server
SQL
0 vote196 views1 answer
What are the aggregate function in sql
SQL
10 votes193 views1 answer
Oracle view dependencies
SQL
3 votes326 views4 answers
Sql interview questions
SQL
0 vote199 views1 answer
Oracle for loop on list
SQL
0 vote213 views1 answer
Enable sql server full text indexing
SQL
7 votes197 views1 answer
Sql server convert string to date
SQL
0 vote166 views1 answer
Get last run query sql server
SQL
5 votes320 views1 answer
Oracle asynchronous procedure
SQL
0 vote230 views1 answer
Sql server create constraint
SQL