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 vote416 views1 answer
Sql insert exemplo
SQL
9 votes317 views3 answers
Where clause sql
SQL
0 vote278 views1 answer
Number(10 2) in sql means
SQL
0 vote293 views1 answer
Pl/ sql change currency
SQL
3 votes282 views1 answer
Select table column in sql
SQL
5 votes290 views1 answer
Minecraft java port number
SQL
3 votes306 views1 answer
Sql case update
SQL
0 vote273 views1 answer
Nueva tabla mysql
SQL
0 vote274 views1 answer
Date diff sql
SQL
0 vote275 views2 answers
Sql server select first day of previous year
SQL