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 vote380 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
3 votes348 views3 answers
Raw select laravel
SQL
0 vote339 views1 answer
Database db connection string format
SQL
0 vote321 views1 answer
Redudancy in SQL
SQL
0 vote358 views1 answer
Drop tables from local database postgres pgadmin
SQL
53 votes535 views6 answers
Sql server alter column
SQL
0 vote352 views1 answer
Primary key multiple
SQL
0 vote329 views1 answer
Report in database
SQL
0 vote312 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote354 views1 answer
Sql get year from datetime field
SQL