Oracle rolling back

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 vote130 views1 answer
Min varias colunas spark sql
SQL
4 votes123 views2 answers
How to delete row in sql
SQL
4 votes120 views1 answer
Mysql copy table with new name
SQL
6 votes131 views2 answers
Postgresql restore from dump
SQL
0 vote150 views1 answer
Mysql could not fetch tables
SQL
6 votes125 views3 answers
Oracle all dates between two dates
SQL
0 vote129 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote129 views1 answer
Dump db only triggers mysql
SQL
19 votes134 views5 answers
Display table in sql
SQL
4 votes126 views1 answer
Oracle delete last row
SQL