Oracle rolling back

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 vote149 views1 answer
Mysql xampp reset root password
SQL
1 vote155 views1 answer
Raw query must include primary key
SQL
2 votes143 views1 answer
Add 2 hours to current time in MySQL
SQL
2 votes142 views2 answers
Change varchar length mysql
SQL
0 vote150 views1 answer
Oracle create table auto generated primary key
SQL
9 votes163 views2 answers
Sql limit to 5 results
SQL
-1 vote159 views1 answer
Add bool column in sql
SQL
0 vote155 views1 answer
Foreign key type uniqu mysql
SQL
3 votes156 views1 answer
Select count from table mysql
SQL
0 vote203 views1 answer
Mysql error 1114 (hy000) the table is full
SQL