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

0 vote160 views1 answer
Edit shchima table in sql
SQL
7 votes130 views4 answers
What is my mysql version
SQL
0 vote128 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote125 views1 answer
Show specific events on mysql
SQL
1 vote123 views1 answer
Reutrn string after character sql
SQL
0 vote147 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote145 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
5 votes156 views2 answers
Oracle list columns
SQL
0 vote169 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote136 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL