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 vote313 views1 answer
Sql select maximum column with other columns returned
SQL
16 votes348 views3 answers
Delete row psql
SQL
1 vote335 views1 answer
What is intersect
SQL
1 vote333 views1 answer
Check message id sql server
SQL
1 vote360 views3 answers
How to truncate table with foreign key constraint
SQL
1 vote349 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote328 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote391 views1 answer
Apt install sql server
SQL
0 vote361 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote332 views1 answer
How to update random rows in sql
SQL