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

3 votes115 views3 answers
Create a view postgres
SQL
0 vote126 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote120 views2 answers
Demmarrer un service mysql teminal cmd
SQL
5 votes164 views1 answer
Mysql created at yesterdau
SQL
0 vote119 views1 answer
Criteria builder select subset of column
SQL
10 votes102 views3 answers
Join multiple tables sql
SQL
0 vote119 views1 answer
Empty table sqlite
SQL
4 votes172 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote134 views1 answer
Mysql could not fetch tables
SQL
0 vote121 views1 answer
Modifier une valeur sql
SQL