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

1 vote212 views1 answer
Sql auto date
SQL
0 vote210 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
1 vote221 views1 answer
Decalre temp table sql
SQL
0 vote212 views1 answer
Mysql server not running
SQL
17 votes218 views3 answers
Postgresql version command
SQL
0 vote245 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote231 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote218 views1 answer
Print hello world in plsql
SQL
3 votes211 views3 answers
List columns in table postgres
SQL
0 vote223 views1 answer
Drop procedure sql
SQL