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

2 votes342 views1 answer
Postgresql change value in column
SQL
0 vote347 views1 answer
Get schema of table sql
SQL
0 vote324 views1 answer
Increment id in mysql
SQL
0 vote385 views2 answers
How to drop mili second in sql
SQL
0 vote345 views1 answer
Sql convert float to string
SQL
2 votes361 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote330 views1 answer
We are intrested to work with your organization
SQL
2 votes340 views1 answer
How to insert string variable into sqlite database
SQL
-1 vote365 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote330 views1 answer
Drop all triggers oracle
SQL