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

1 vote435 views1 answer
Oracle select first row order by
SQL
0 vote370 views1 answer
Sql revert migration
SQL
0 vote349 views1 answer
Sql server update top n records
SQL
2 votes381 views1 answer
Sqlplus clear screen
SQL
2 votes382 views2 answers
Storing timezones in postgres
SQL
1 vote375 views2 answers
How to check if sql query is correct online
SQL
0 vote353 views1 answer
Optimize sql query
SQL
0 vote359 views2 answers
Cascade syntax in sql
SQL
18 votes307 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote401 views1 answer
Postgres rename database
SQL