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

2 votes181 views1 answer
Sql column values comma separated
SQL
0 vote178 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote182 views1 answer
Insert set mysql
SQL
0 vote216 views1 answer
What is initial catalog in sql connection string
SQL
0 vote187 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
1 vote177 views2 answers
Sql select only first occurrence
SQL
0 vote196 views1 answer
Data directory postgresql
SQL
16 votes185 views2 answers
Mysql date between two dates
SQL
1 vote187 views1 answer
Create temporal table in sql
SQL
6 votes251 views3 answers
Rename column ORACLE
SQL