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

0 vote278 views2 answers
Postgresql display subquery as json
SQL
0 vote274 views2 answers
Sql drop view if exists
SQL
3 votes264 views1 answer
Oracle undo tablespace list by user
SQL
15 votes262 views2 answers
How to drop database name in postgresql
SQL
3 votes282 views2 answers
Enter mysql command line
SQL
0 vote266 views1 answer
Output to file mysql
SQL
0 vote265 views1 answer
Resulting Query
SQL
3 votes241 views1 answer
If 0 return null else return query mysql
SQL
0 vote296 views1 answer
How to find symmetric pairs in sql
SQL
6 votes283 views1 answer
Sql insert values into table
SQL