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 vote203 views1 answer
Connect to ssms with python
SQL
1 vote239 views2 answers
Sql split string by space
SQL
0 vote203 views1 answer
Mariadb errno 121
SQL
0 vote206 views1 answer
Sql where part of string match
SQL
0 vote204 views1 answer
Database xml sql
SQL
0 vote208 views1 answer
Frename oracle
SQL
0 vote247 views2 answers
Remove mysql workbench ubuntu
SQL
19 votes227 views3 answers
How to change column type psql
SQL
0 vote159 views1 answer
Check if has alpha characters sql
SQL
2 votes210 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL