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

0 vote256 views1 answer
Oracle exchange partition
SQL
7 votes285 views6 answers
Mysql group concat
SQL
0 vote247 views1 answer
Get last updated row sql server
SQL
13 votes269 views2 answers
Sql join 3 tables
SQL
4 votes397 views6 answers
Laravel jwt
SQL
0 vote270 views1 answer
Change filed order in mysql
SQL
0 vote228 views1 answer
Postgres create database if not exists
SQL
0 vote276 views1 answer
Create user faunadb
SQL
-1 vote226 views10 answers
Delete Query in SQL Server
SQL
0 vote271 views1 answer
Where to find pg_hba.conf in ubuntu
SQL