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 vote211 views1 answer
Mysql select row with min date
SQL
10 votes248 views5 answers
Create table mysql query
SQL
0 vote223 views1 answer
Sql server pivot rows to columns
SQL
0 vote247 views1 answer
Transaction and commit trong sql server
SQL
0 vote228 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote231 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote258 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote227 views1 answer
Mysql changer nom table
SQL
-2 votes255 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote243 views1 answer
Sql how to get courses that i have made prerequisites
SQL