//查询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';
以此类推
使用Oracle命令查询Function,Table . .etc
最新推荐文章于 2024-07-17 11:44:07 发布