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

5 votes268 views2 answers
Add days in oracle sql
SQL
24 votes207 views4 answers
Mysql datetime
SQL
1 vote231 views1 answer
Postgresql update auto_increment value
SQL
5 votes194 views3 answers
Oracle first day of last year
SQL
0 vote187 views1 answer
How to order result of subquery in select
SQL
0 vote184 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote237 views1 answer
Count of tables in database mysql
SQL
0 vote220 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote260 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote191 views1 answer
Drop df constraint sql server
SQL