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

12 votes141 views1 answer
Script to add new column in table sql
SQL
0 vote137 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote144 views1 answer
How to join result table in mysql
SQL
4 votes126 views1 answer
Mysql insert from local csv
SQL
0 vote150 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
2 votes182 views2 answers
Postgres drop column if exists
SQL
0 vote176 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote131 views1 answer
Sql restore backup query
SQL
0 vote122 views1 answer
Concat column value of same user in mysql
SQL
0 vote143 views1 answer
Sql alter table order by
SQL