Find COMMITs and ROLLBACKs in Code with PL/Scope 12.2

View All Scripts Login to Run Script

Script Name Find COMMITs and ROLLBACKs in Code with PL/Scope 12.2
Description With 12.2's enhancement to PL/Scope to also gather data on SQL statements in your PL/SQL code, it's a snap to find all COMMIT and ROLLBACK statements in your code! Doc: http://docs.oracle.com/database/122/ADFNS/plscope.htm#ADFNS022
Area PL/SQL General
Contributor Steven Feuerstein
Created Friday June 09, 2017

Statement 1

Find all COMMITs

SELECT st.object_name, 
       st.object_type, 
       st.line, 
       src.text 
  FROM user_statements st, user_source src 
 WHERE     st.TYPE = 'COMMIT' 
       AND st.object_name = src.name 
       AND st.line = src.line 
ORDER BY st.object_name, 
         st.object_type

no data found

Statement 2

Find all ROLLBACKs

SELECT st.object_name, 
       st.object_type, 
       st.line, 
       src.text 
  FROM user_statements st, user_source src 
 WHERE     st.TYPE = 'ROLLBACK' 
       AND st.object_name = src.name 
       AND st.line = src.line 
ORDER BY st.object_name, 
         st.object_type

no data found

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database