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 vote9.7K views1 answer
Postgresql delete type
SQL
1 vote175 views1 answer
Drush sql-dump
SQL
0 vote168 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
2 votes188 views1 answer
Oracle convert run_duration to number
SQL
1 vote137 views1 answer
Pagination sql
SQL
0 vote186 views1 answer
Mysql server not running
SQL
0 vote183 views1 answer
Sql count * vs count 1
SQL
10 votes167 views1 answer
Oracle dependency
SQL
0 vote231 views1 answer
Create table as select sql server error
SQL
10 votes188 views3 answers
Sql check double value
SQL