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 vote148 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote166 views1 answer
How to get button for every record from mysql
SQL
0 vote165 views1 answer
Mysql get nth highest
SQL
2 votes155 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote139 views1 answer
Connecting to my cloud sql server with c#
SQL
27 votes172 views3 answers
Mysql show tables in database
SQL
0 vote161 views1 answer
How to install Firebird
SQL
0 vote210 views2 answers
Wordpress change url in database
SQL
0 vote155 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote142 views1 answer
Renommer table sql
SQL