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

19 votes340 views5 answers
Display table in sql
SQL
7 votes295 views1 answer
Postgres base size
SQL
0 vote297 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
1 vote302 views1 answer
Get last week data in mysql
SQL
0 vote327 views2 answers
Replace null with 0 in sql
SQL
1 vote304 views2 answers
Changes not showing on website server odoo
SQL
0 vote300 views1 answer
Mysql get last 2 month data
SQL
2 votes264 views1 answer
Mysql admin u root p password change password
SQL
16 votes285 views2 answers
Gremove folder from git
SQL
0 vote322 views1 answer
Plsql find location of procedure
SQL