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 vote207 views1 answer
How to check default value of column in sql server
SQL
1 vote266 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote176 views1 answer
Mysql select all table that have field names
SQL
0 vote179 views1 answer
Insufficient memory to excute the sql query
SQL
2 votes171 views1 answer
How to delete columns in sql
SQL
0 vote196 views1 answer
How to change mysql root password in windows 10
SQL
8 votes207 views1 answer
My sql version
SQL
4 votes176 views2 answers
Postgres update single column
SQL
0 vote206 views1 answer
Sql string contains case sensitive
SQL
6 votes185 views1 answer
Oracle trigger after connect
SQL