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 vote196 views1 answer
Declare or use variable in snowflake
SQL
8 votes179 views1 answer
How to check mysql version in xampp
SQL
0 vote183 views1 answer
Mysql cli output to a file
SQL
0 vote164 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote176 views1 answer
Openquery join two tables
SQL
0 vote178 views1 answer
Create relationship with betwen two tables in postgersql
SQL
2 votes170 views1 answer
Mysql trigger after update
SQL
1 vote177 views1 answer
Select if then postgresql
SQL
0 vote173 views1 answer
Max mysql
SQL
1 vote171 views1 answer
Multiple count in sql
SQL