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

4 votes133 views1 answer
Create table if not exist in sqlite
SQL
1 vote94 views2 answers
Procedure pl/sql
SQL
10 votes138 views2 answers
Forgot my mysql password mac
SQL
0 vote118 views1 answer
Get records in sql according to month name and count
SQL
7 votes127 views1 answer
Sql disable safe mode
SQL
5 votes141 views1 answer
AND OR NOT operators sql
SQL
1 vote129 views1 answer
Mysql get domain from url
SQL
10 votes156 views6 answers
Mysql set root password
SQL
4 votes141 views1 answer
Sql data types
SQL
0 vote136 views1 answer
Sql show founctions
SQL