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

1 vote271 views1 answer
Postgres first_value in gropby
SQL
0 vote273 views1 answer
Cannot start database server xampp mac os
SQL
1 vote306 views1 answer
Mysql select row max date
SQL
0 vote302 views1 answer
Mysql dump with table query
SQL
0 vote257 views1 answer
How to save data in database in mysql node
SQL
0 vote277 views1 answer
Custom row number
SQL
8 votes281 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote256 views1 answer
Go install mysql
SQL
0 vote310 views1 answer
For row in sql database python loop
SQL
0 vote321 views1 answer
Sql values that contains certain multiple ids
SQL