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 vote102 views1 answer
Suse status MySQL
SQL
0 vote105 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote110 views1 answer
Create database store
SQL
1 vote96 views1 answer
Copy postgres table from one schema into another
SQL
0 vote89 views1 answer
Load utilities in sql server
SQL
1 vote101 views1 answer
Delete mysql from mac
SQL
0 vote98 views1 answer
Call function sql oracle with output put line
SQL
2 votes98 views1 answer
Set username and password for postgresql database
SQL
0 vote99 views1 answer
Mysql count by month
SQL
2 votes115 views1 answer
Postgresql create schema in specific database
SQL