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

6 votes215 views2 answers
Mysql concatenate two columns into one
SQL
1 vote225 views1 answer
Get current date in pyspark sql
SQL
0 vote210 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote202 views1 answer
Sql value exists in column
SQL
1 vote220 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
1 vote240 views1 answer
Create email address from first and last name in sql
SQL
0 vote199 views1 answer
Oracle last connection
SQL
0 vote210 views1 answer
Insert output identity
SQL
0 vote211 views1 answer
Python connect microsoft sql server
SQL
0 vote201 views1 answer
Postgresql alter column nullable
SQL