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

3 votes190 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote191 views1 answer
Update sql sintax
SQL
0 vote197 views1 answer
Oracle sql date winter time
SQL
5 votes147 views1 answer
Invalid column name sql
SQL
0 vote223 views1 answer
How to add auto increment primary key
SQL
1 vote155 views1 answer
Set mysql mode global query
SQL
0 vote189 views1 answer
Wordpress make wp user in db
SQL
0 vote242 views1 answer
Site:av.ru "files"
SQL
1 vote169 views1 answer
Sql select table header
SQL
-1 vote147 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL