改成大写，小写是查不出来的 select object_name,created,status from user_objectswhere lower(object_type) in ('procedure','function');
