Oracle rolling back transactions

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 vote199 views1 answer
Sql update subtract value
SQL
11 votes199 views1 answer
Oracle export view ddl
SQL
8 votes191 views4 answers
How to calculate the age from date of birth in python
SQL
5 votes195 views2 answers
Get number of columns sql
SQL
0 vote207 views1 answer
Sql date time query find
SQL
0 vote185 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote174 views1 answer
Oracle list subpartitions
SQL
1 vote205 views1 answer
Oracle sql pad left zeros
SQL
0 vote189 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
5 votes172 views2 answers
Sql conn
SQL