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

17 votes130 views3 answers
How to change a collumn name in sql
SQL
0 vote139 views1 answer
How to get data from 2 database
SQL
-1 vote71 views1 answer
Mysql how to set update or create
SQL
0 vote126 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
2 votes154 views1 answer
Select from array in psql
SQL
1 vote109 views1 answer
Oracle explain plan
SQL
0 vote125 views1 answer
Sqlalchemy one column of two has to be not null
SQL
5 votes122 views3 answers
MySql get fields of table
SQL
2 votes147 views1 answer
Search query in mysql
SQL
7 votes124 views3 answers
Python and mysql connectivity
SQL