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 vote174 views1 answer
Sql missing values
SQL
0 vote180 views1 answer
Sql revert migration
SQL
3 votes175 views1 answer
Sql replace character in string in all records
SQL
0 vote158 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
11 votes213 views2 answers
Having keyword sql
SQL
0 vote150 views1 answer
Error code 1241 mysql
SQL
0 vote172 views2 answers
Temp tables in sql server
SQL
4 votes163 views1 answer
Sql any
SQL
0 vote159 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote186 views2 answers
Mysql row_number() example
SQL