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 vote293 views1 answer
Update one column from another column in same table
SQL
0 vote508 views1 answer
Get first match in each group mysql query
SQL
0 vote286 views3 answers
Convert sql query to python pandas
SQL
0 vote315 views1 answer
Stored procedures example
SQL
0 vote285 views1 answer
Mysql identified by syntax error
SQL
1 vote258 views1 answer
Metada in sql
SQL
0 vote285 views1 answer
Database timezone
SQL
1 vote298 views1 answer
Mysql how to reset primary key
SQL
3 votes304 views1 answer
Uppercase and lowercase in sql
SQL
1 vote282 views1 answer
Using SQL in rails migration
SQL