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 vote293 views1 answer
Sql developer export connections
SQL
0 vote185 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
4 votes197 views4 answers
Mysql get date from datetime
SQL
1 vote165 views1 answer
Sql comment header
SQL
1 vote176 views1 answer
Base64 encode sql server
SQL
0 vote187 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote173 views1 answer
Print hello world in plsql
SQL
2 votes186 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
9 votes203 views3 answers
Sql delete where in
SQL
0 vote176 views1 answer
How to insert a uniqueidentifier in sql
SQL