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

1 vote186 views2 answers
T sql get foreign key
SQL
0 vote178 views1 answer
How to reset AI in sql
SQL
1 vote198 views1 answer
Mysql login console
SQL
11 votes173 views2 answers
Docker create postgres db
SQL
0 vote181 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote186 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote177 views2 answers
Sqlite
SQL
0 vote176 views1 answer
Sql mod even odd
SQL
14 votes191 views4 answers
Remove record from table sql
SQL
0 vote180 views1 answer
Learn sqlite dart
SQL