Oracle rolling back

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

4 votes253 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
15 votes279 views3 answers
Postgresql change column type
SQL
11 votes254 views2 answers
MySQL DISTINCT
SQL
0 vote267 views1 answer
Synapse sql table set pk
SQL
0 vote263 views1 answer
Sql insert from excel
SQL
0 vote273 views1 answer
Select lowest values sql
SQL
0 vote245 views1 answer
Oracle sql date summer time
SQL
0 vote276 views2 answers
Mysql calcular idade
SQL
4 votes272 views2 answers
Sql offset
SQL
7 votes250 views3 answers
How to check table name in current database sql
SQL