Oracle Alerts

SELECT a.* FROM ALR_ALERTS a WHERE ALert_Name LIKE 'XXX%Eco%';
SELECT * FROM ALR_ACTIONS WHERE UPPER(to_recipients) LIKE '%CHUA%';