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

0 vote138 views2 answers
Soql last year
SQL
0 vote130 views1 answer
Add plugins to mysql workbench
SQL
0 vote188 views1 answer
Having all mysql
SQL
3 votes144 views2 answers
Tsql join multiple record in one string
SQL
0 vote136 views1 answer
Sql server udf performance
SQL
18 votes175 views3 answers
Get the list of all tables in sql server
SQL
0 vote147 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
33 votes139 views6 answers
Change column name in mysql
SQL
0 vote127 views1 answer
Sql beginning of previous month
SQL
1 vote136 views1 answer
Primary key with prefix sql
SQL