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

50 votes251 views4 answers
Sql alter type of column
SQL
1 vote260 views1 answer
Nullif postgresql
SQL
-1 vote216 views2 answers
How to display top 50 rows?
SQL
14 votes230 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote222 views1 answer
How to print out column name differently in mysql
SQL
49 votes234 views6 answers
Get duplicate records in sql
SQL
0 vote235 views1 answer
Oracle sql developer closed connection
SQL
0 vote223 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote276 views1 answer
Mysql concatenate select results
SQL
2 votes220 views1 answer
Oracle table size
SQL