Oracle rolling back transactions

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 vote283 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote280 views1 answer
Find usage of table in sql server
SQL
0 vote323 views2 answers
Fanyi
SQL
5 votes264 views2 answers
Mysql drop table cascade
SQL
0 vote274 views2 answers
SQL BULK INSERT
SQL
-1 vote275 views1 answer
Mysql change database charset and collation
SQL
0 vote277 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote286 views1 answer
Mysqli last row
SQL
0 vote256 views1 answer
Create api project in visual studio 2019 and sql server
SQL
7 votes259 views2 answers
Sql server drop temp table if exists
SQL