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 vote124 views1 answer
Sql getdate date only
SQL
0 vote133 views1 answer
Find and replace query in wordpress\
SQL
0 vote151 views1 answer
Count database access django
SQL
4 votes161 views3 answers
Postgres drop all tables
SQL
1 vote175 views1 answer
Show databases mysql docker
SQL
1 vote130 views4 answers
Fatal database postgres does not exist
SQL
0 vote189 views1 answer
Sql int vs integer
SQL
0 vote129 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote125 views1 answer
Automate mysql cli query
SQL
0 vote130 views1 answer
Sql last 7 days
SQL