Simple Topic let you know what is the database object for specific user
SELECT object_name, object_type
FROM all_objects
WHERE owner = 'SYS'
AND object_type IN ('PACKAGE', 'PACKAGE BODY')
ORDER BY object_name, object_type;
Thank you
Osama Mustafa
Technology Geek 
Leave a comment