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

25 votes244 views6 answers
Change column name mysql
SQL
22 votes239 views4 answers
Mysql date format
SQL
9 votes263 views3 answers
Date format in sql
SQL
0 vote235 views1 answer
MySql Modify Increment
SQL
1 vote229 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote231 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote236 views1 answer
Using GROUP BY in MySQL Join Table
SQL
17 votes256 views4 answers
Postgres list users
SQL
0 vote227 views1 answer
Postgresql log
SQL
0 vote237 views1 answer
Sql server system messeges
SQL