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 vote232 views1 answer
How do you use sql in you company
SQL
0 vote193 views1 answer
RowDataPacket
SQL
0 vote205 views1 answer
Open postgresql.conf in centos
SQL
3 votes231 views5 answers
Duplicate table sql
SQL
0 vote213 views2 answers
Postgresql variable in query
SQL
0 vote214 views1 answer
Count characters of string mysql
SQL
2 votes205 views2 answers
Select list is not in group by clause
SQL
0 vote210 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote211 views1 answer
Describe in sqlite3
SQL
0 vote213 views1 answer
Psql show db
SQL