//查询FUNCTION对象

SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'FUNCTION';


//查询表对象

SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE';


//查询索引

SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'INDEX';


以此类推