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

9 votes244 views3 answers
Sequence postgresql
SQL
0 vote247 views2 answers
Sql server select where date
SQL
1 vote256 views1 answer
Mysql select another database
SQL
0 vote251 views1 answer
Casterar postgres
SQL
0 vote297 views1 answer
Dual in db2
SQL
-1 vote254 views2 answers
Get day in sql
SQL
0 vote247 views2 answers
Plsql function that return a table
SQL
-1 vote244 views2 answers
Full join sql
SQL
0 vote246 views1 answer
Why mysql is used?
SQL
10 votes256 views1 answer
Oracle object dependencies
SQL