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 vote380 views1 answer
Wherein mysql
SQL
0 vote358 views2 answers
Alter table add multiple columns mysql
SQL
0 vote368 views1 answer
Oracle sql number to varchar2
SQL
1 vote402 views1 answer
Encrypt password postgresql
SQL
0 vote371 views1 answer
On delete set default
SQL
1 vote334 views1 answer
Create sample data postgresql
SQL
0 vote348 views1 answer
Psql select * from table
SQL
1 vote368 views1 answer
Print year of a date sql
SQL
0 vote336 views1 answer
How to check if there is no database schema
SQL
12 votes343 views2 answers
Delete all nodes neo4j
SQL