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 vote138 views1 answer
Create schema sql server
SQL
0 vote179 views1 answer
Mysl like insert a variable
SQL
7 votes141 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote159 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote132 views1 answer
Using SQL in rails migration
SQL
1 vote178 views1 answer
Backup mysql schema only
SQL
0 vote169 views2 answers
Mysql show foreign keys
SQL
0 vote167 views3 answers
Constraint sql
SQL
0 vote156 views1 answer
How to input data as id in database sql c#
SQL
0 vote165 views1 answer
Sql describe
SQL