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

0 vote354 views3 answers
Get free card roblox
SQL
0 vote355 views1 answer
Oserror mysql_config not found virtualenv
SQL
4 votes357 views1 answer
Sql group by year
SQL
1 vote350 views1 answer
Alter table column size oracle
SQL
3 votes379 views1 answer
APEX elapsed time
SQL
0 vote351 views1 answer
Get records in sql according to month name and count
SQL
0 vote362 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote410 views1 answer
Sql ssrs
SQL
4 votes372 views2 answers
Select first and last row mysql
SQL
0 vote455 views1 answer
Sqlite display headers on columns
SQL