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

8 votes108 views2 answers
Between operator
SQL
0 vote123 views2 answers
Compound operator in sql
SQL
17 votes114 views4 answers
Postgres list users
SQL
0 vote111 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote124 views2 answers
Impala rename column name
SQL
1 vote100 views1 answer
Mysql check if string contains comma separated
SQL
0 vote105 views1 answer
Mysql locate
SQL
0 vote106 views1 answer
Oracle job class
SQL
3 votes174 views1 answer
Oracle show trigger code
SQL
3 votes118 views3 answers
Raw select laravel
SQL