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

19 votes308 views5 answers
Change column name mysql command line
SQL
1 vote359 views4 answers
How to check table in postgresql from terminal
SQL
2 votes319 views1 answer
Sql server check for value in multiple columns
SQL
0 vote298 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote287 views1 answer
Sql roll up rows into columns
SQL
2 votes299 views1 answer
Sql skip the first row
SQL
2 votes292 views1 answer
Select from array in psql
SQL
10 votes337 views2 answers
Doublon sql
SQL
0 vote308 views1 answer
Linebreak sql
SQL
3 votes305 views2 answers
Monthname sql
SQL