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 vote141 views1 answer
Narural join
SQL
0 vote124 views1 answer
Mysql percentage of total
SQL
2 votes123 views1 answer
Sql to char function with date
SQL
0 vote138 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
2 votes122 views1 answer
Oracle create directory
SQL
0 vote136 views1 answer
Pl sql turn off variable substitution
SQL
0 vote140 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote122 views1 answer
Mysql multiple count
SQL
3 votes135 views1 answer
Two select sql
SQL
1 vote142 views1 answer
Get create table query existing table mysql
SQL