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 vote309 views1 answer
Select all tables linked server sql
SQL
0 vote330 views1 answer
How to check which table has data in mysql
SQL
0 vote347 views2 answers
Temp tables in sql server
SQL
0 vote301 views1 answer
How to to get current date and time in sql
SQL
2 votes308 views1 answer
No data found oracle
SQL
-2 votes332 views4 answers
How to get max salary in each department in sql
SQL
1 vote358 views1 answer
Postgres see sequence current state
SQL
2 votes309 views2 answers
Mysql date range
SQL
1 vote327 views2 answers
Begin transaction in sql
SQL
0 vote303 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL