oracle8.1.6 select object_type as type, object_name as name from user_objects where object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION') order by decode(object_type, 'PACKAGE', 0, 'PROCEDURE', 1, 'FUNCTION', 2) asc