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

1 vote345 views1 answer
Check constraint to check if date greater than todays date
SQL
9 votes360 views6 answers
Sql add column with default value
SQL
0 vote338 views1 answer
Drop all tables in azure sql database
SQL
2 votes396 views1 answer
How to check if a row is null in sql
SQL
2 votes392 views2 answers
Create table mysql integer NOT null
SQL
3 votes379 views1 answer
Oracle APEX elapsed time
SQL
1 vote349 views1 answer
Mysql copy table1 to table2
SQL
0 vote398 views1 answer
How to compile a function in oracle
SQL
0 vote313 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote416 views1 answer
Query for backup a database at another location in file system
SQL