SELECT object_name
FROM user_objects
WHERE object_type = 'PACKAGE';
 
SELECT object_name, argument_name, position, data_type, data_length 
FROM user_arguments
WHERE package_name = 'test_pkg'
ORDER BY object_name, position; 
Retrieve PACKAGE Source Code SELECT text
FROM user_source
WHERE name = 'test_pkg'; 
 
================================ 
 
Overloaded Packages 
 
SELECT overload, COUNT(*)
FROM all_arguments
WHERE overload IS NOT NULL
GROUP BY overload
HAVING COUNT(*) > 1
ORDER BY TO_NUMBER(overload);