Oracle rolling back transactions

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 vote382 views1 answer
How to convert external table to managed table in hive
SQL
0 vote324 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote339 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote347 views2 answers
How covert into int in maria db
SQL
0 vote292 views1 answer
Now() -1 mysql
SQL
15 votes334 views3 answers
Create table with primary key auto increment in sql
SQL
11 votes376 views2 answers
Having clause in sql
SQL
0 vote347 views1 answer
Sql query to find duplicate email address
SQL
0 vote356 views1 answer
MySQL INSERT IGNORE Statement
SQL
5 votes338 views1 answer
Oracle create table comment
SQL