Cacher is the code snippet organizer for pro developers

Schow all packages like 'SUPPORT_CATEGORIES%'; other OBJECT_TYPE examples: PACKAGE, PACKAGE BODY, PROCEDURE, FUNCTION, TRIGGER

SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('PACKAGE')
AND OBJECT_NAME like 'SUPPORT_CATEGORIES%';