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 vote122 views1 answer
Grant privileges of databse to user
SQL
1 vote120 views1 answer
Last 6 months postgresql
SQL
1 vote108 views1 answer
Postgresql update auto_increment value
SQL
8 votes123 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote127 views1 answer
Trigger vérifier stock
SQL
0 vote121 views1 answer
Offset in postgresql example
SQL
10 votes104 views3 answers
Insert into auto increment mysql
SQL
2 votes133 views2 answers
Sql lag
SQL
4 votes135 views6 answers
Select sql
SQL
-1 vote130 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL