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 vote359 views1 answer
Spring boot mysql connection properties
SQL
3 votes329 views3 answers
Mysql get table size
SQL
0 vote338 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote339 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
1 vote350 views1 answer
Copy postgres table from one schema into another
SQL
-1 vote289 views2 answers
Datetime sql server week
SQL
0 vote351 views1 answer
How to connect pgadmin with excel
SQL
4 votes358 views2 answers
Sql offset
SQL
0 vote341 views1 answer
Sql create table with datetime automatically
SQL
7 votes332 views1 answer
Query delete duplicates
SQL