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

2 votes156 views1 answer
How to check if a row is null in sql
SQL
4 votes176 views1 answer
List tables sqlite
SQL
0 vote159 views1 answer
Mod in sql
SQL
60 votes455 views6 answers
Add column in sql
SQL
0 vote168 views3 answers
Postgresql allow remote connections
SQL
0 vote149 views2 answers
Mysql output csv
SQL
4 votes242 views1 answer
Sql select limit range
SQL
0 vote237 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
1 vote177 views1 answer
Postgresql update auto_increment value
SQL
0 vote149 views1 answer
2020 new year
SQL