Friday, January 28, 2022

Query to find Oracle Alert

The following query finds all enabled custom alerts. You can comment out the very last two lines (alr.enabled_flag and alr.created_by) to display all both enabled and disabled alerts.


-- Query to find Custom Oracle Alert


SELECT alr.application_id,






  FROM alr.alr_alerts alr

 WHERE 1=1

   AND alr.created_by <> 1      -- show only custom alerts

   AND alr.enabled_flag = 'Y';  -- show only enabled alerts

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...