Answers for "rolling back. in oracle"

SQL
1

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');
Posted by: Guest on September-11-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language