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 vote238 views1 answer
Sintaxis SELECT sql
SQL
0 vote148 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
6 votes267 views2 answers
Non relational database
SQL
1 vote176 views1 answer
Mysql select utc time in eastern time
SQL
0 vote186 views1 answer
Add timestamp column to existing table t-sql
SQL
2 votes190 views3 answers
Replace null in sql
SQL
5 votes198 views2 answers
Oracle list columns
SQL
0 vote193 views1 answer
Cube oracle
SQL
0 vote188 views1 answer
Sql select where more than one record exists
SQL
3 votes186 views2 answers
How to start postgresql on windows
SQL