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

1 vote135 views2 answers
Mysql trim spaces
SQL
1 vote190 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote147 views1 answer
DATEDIFF minute postgres
SQL
11 votes132 views2 answers
Turn off safe mode mysql
SQL
3 votes126 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote114 views1 answer
Is not null postgresql
SQL
1 vote157 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
1 vote132 views1 answer
Round one decimal place mysql
SQL
0 vote133 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote126 views1 answer
Postgres where
SQL