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

6 votes140 views6 answers
Count mysql
SQL
0 vote176 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote148 views1 answer
Why mysql is used?
SQL
3 votes178 views4 answers
Mysql create table from select statement
SQL
0 vote145 views1 answer
Write sql query to show the details start from digit
SQL
-1 vote145 views2 answers
Postgres autoincrement primary key
SQL
0 vote140 views1 answer
Mysql undo delete
SQL
4 votes179 views1 answer
How to drop a database in sql server when it is in use
SQL
8 votes149 views1 answer
Oracle all_source package body
SQL
0 vote144 views1 answer
Sql query to delete row by id
SQL