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

0 vote204 views2 answers
Sql query unique
SQL
0 vote224 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
10 votes217 views2 answers
Sql merge statement
SQL
0 vote221 views1 answer
Gcloud sql instance list
SQL
0 vote210 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
1 vote209 views1 answer
Set statistics on in ssms
SQL
0 vote211 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote221 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote221 views1 answer
Mysql join only one column
SQL
0 vote224 views1 answer
How to add unique key constraint in mysql
SQL