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 vote114 views1 answer
Modifier une valeur sql
SQL
0 vote107 views1 answer
See the structure of a table mysql
SQL
0 vote103 views1 answer
Sql compound operators
SQL
0 vote107 views2 answers
Oracle sql for each row
SQL
1 vote139 views1 answer
Sql server set variable if exists
SQL
0 vote116 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote110 views1 answer
Get first monday of month sql
SQL
10 votes104 views5 answers
Create table mysql query
SQL
0 vote109 views1 answer
How to check default value of column in sql server
SQL
0 vote130 views1 answer
Ubuntu connect to mssql database
SQL