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

8 votes118 views1 answer
Oracle all_source package body
SQL
0 vote117 views2 answers
How to get json data mysql
SQL
11 votes121 views4 answers
Update row in mysql
SQL
0 vote155 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote118 views1 answer
SQL get max per id
SQL
4 votes110 views1 answer
Force drop all tables postgres
SQL
0 vote111 views1 answer
Safe mysql
SQL
-2 votes123 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote125 views1 answer
Sql ignore
SQL
0 vote108 views3 answers
Get count of null in column sql
SQL