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 vote225 views1 answer
MySQL update with subquery
SQL
0 vote174 views1 answer
Sql pad left 0
SQL
2 votes166 views4 answers
Duplicate record mysql
SQL
0 vote165 views1 answer
Sql server inner join convert collation
SQL
2 votes324 views1 answer
Set auto increment from 1
SQL
0 vote217 views1 answer
Sql cheetsheet
SQL
0 vote190 views1 answer
Sql select lowest value row
SQL
0 vote201 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote187 views1 answer
Sql last 3 rows
SQL
4 votes185 views1 answer
Oracle user tables
SQL