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 vote251 views1 answer
Alter precision
SQL
-1 vote254 views3 answers
Update mongodb version ubuntu
SQL
0 vote268 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote263 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
1 vote264 views1 answer
Psql lst trigger
SQL
0 vote247 views1 answer
Mysql autoincrement valor inicial
SQL
2 votes277 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
1 vote260 views1 answer
Lpad function in sql oracle
SQL
0 vote239 views1 answer
Opensuse status MySQL
SQL
11 votes259 views2 answers
Oracle all source
SQL