Oracle rolling back transactions

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

2 votes204 views1 answer
Q operator in plsql
SQL
0 vote249 views1 answer
T-SQL Create Trigger
SQL
36 votes211 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote208 views1 answer
Postgresql not in alternative
SQL
0 vote192 views1 answer
Get records in sql according to month name and count
SQL
0 vote208 views1 answer
Sql server user permissions and roles
SQL
7 votes253 views1 answer
Sql disable safe mode
SQL
0 vote201 views1 answer
Sql dmv to capture updates
SQL
1 vote200 views2 answers
Sql groub by count
SQL
0 vote228 views3 answers
Join
SQL