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 vote287 views1 answer
Postgres in operator with comma separated values
SQL
19 votes307 views6 answers
Create table sqlite
SQL
0 vote287 views1 answer
View acl table oracle
SQL
0 vote278 views1 answer
Alter precision
SQL
3 votes246 views2 answers
Mysql sum with condition
SQL
1 vote279 views1 answer
How to see all table partition in oracle
SQL
0 vote288 views1 answer
Fill up postgres db
SQL
0 vote298 views1 answer
How to move a column to different spot mysql
SQL
1 vote320 views1 answer
Primary key with prefix sql
SQL
1 vote271 views1 answer
Foreign key constraint in ms sql
SQL