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

2 votes151 views1 answer
Oracle sql drop table purge
SQL
-1 vote222 views1 answer
MYSQL stored procedure select from
SQL
1 vote159 views1 answer
Round function in sql oracle
SQL
0 vote190 views1 answer
Varchar format not case sensitive sql
SQL
0 vote176 views1 answer
Postgresql check total storage
SQL
2 votes206 views6 answers
In operator in sql
SQL
1 vote164 views1 answer
Table information in sql server
SQL
0 vote175 views1 answer
Insert using condition postgres
SQL
0 vote166 views1 answer
Postgresql delete multiple rows
SQL
27 votes207 views6 answers
Sql update record
SQL