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

8 votes191 views4 answers
Mysql update one table from another table multiple columns
SQL
1 vote200 views1 answer
Oracle case
SQL
1 vote241 views1 answer
Postgresql append array
SQL
4 votes191 views2 answers
Linq join
SQL
19 votes192 views2 answers
Mysql add column after another
SQL
0 vote190 views1 answer
Install mysql for fedora 34
SQL
-1 vote188 views2 answers
On update cascade
SQL
0 vote221 views1 answer
Query for backup a database at another location in file system
SQL
0 vote205 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
1 vote212 views1 answer
How to run parallel queries in sql server with entity framework
SQL