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

15 votes320 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote269 views1 answer
Ms sql print more than 1 variable
SQL
1 vote379 views1 answer
How not to sort by average rating
SQL
0 vote313 views1 answer
Comma seperated join mssql
SQL
0 vote377 views1 answer
Delete hangfire retries list
SQL
9 votes311 views4 answers
How to remove duplicate in sql
SQL
0 vote381 views1 answer
Get initial in sql
SQL
2 votes330 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote336 views1 answer
Postgresql delete type
SQL
0 vote281 views1 answer
Java spring boot connect to sql server
SQL