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 votes238 views2 answers
Postgres timestamp to datetime
SQL
1 vote222 views1 answer
Sql server locks
SQL
0 vote175 views1 answer
Mariadb datetime change to microseconds
SQL
13 votes163 views2 answers
Mysql order by multiple columns
SQL
0 vote174 views2 answers
Mysql to python pandas
SQL
0 vote170 views1 answer
Mysql drop multiple tables at once
SQL
0 vote156 views1 answer
How to get initials in sql
SQL
7 votes176 views2 answers
Mysql check db size
SQL
0 vote166 views1 answer
Cross apply top for each row t1
SQL
1 vote205 views3 answers
How to create a table structure from another table in mysql
SQL