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 vote242 views1 answer
Varchar2 length in oracle
SQL
4 votes205 views1 answer
Sql list users and roles
SQL
3 votes242 views1 answer
Sql multi column index performance
SQL
0 vote263 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote224 views1 answer
Rabbitmq service not starting
SQL
0 vote233 views1 answer
Sql remove first character from string
SQL
-1 vote259 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote228 views1 answer
How to change the field size of an existing column
SQL
4 votes240 views1 answer
Create db table
SQL
8 votes228 views3 answers
Alter table auto_increment
SQL