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 vote198 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote186 views1 answer
Sql delete where x or y or z
SQL
8 votes198 views1 answer
Oracle create datafile
SQL
0 vote205 views1 answer
Mariadb maximum left join
SQL
0 vote210 views1 answer
Postgresql inline table
SQL
0 vote183 views1 answer
Inser into example
SQL
0 vote205 views1 answer
Mysql query single row
SQL
2 votes279 views2 answers
Null column to 0 in mysql
SQL
0 vote236 views1 answer
Sql alter table order by
SQL
1 vote204 views1 answer
Sql select where id not exists in another table
SQL