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

4 votes325 views3 answers
Employee name starting with in sql
SQL
0 vote317 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote326 views1 answer
T-SQL Create Trigger
SQL
1 vote308 views2 answers
Mysql error 1215
SQL
0 vote317 views1 answer
Alter fedora mysql 8.0 user
SQL
-1 vote297 views2 answers
Full join sql
SQL
0 vote333 views1 answer
How to update date value in sql
SQL
3 votes315 views1 answer
Force using index oracle
SQL
0 vote352 views1 answer
Oracle sql developer closed connection
SQL
0 vote354 views2 answers
Mysql insert into multiple tables
SQL