Oracle 视图 USER_PLSQL_OBJECT_SETTINGS 官方解释，作用，如何使用详细说明

本站中文解释

该视图的用途是查看用户在Oracle数据库中创建的PL/SQL对象的设置

其字段包括：

1、OBJECT_NAME：PL/SQL对象名
2、OBJECT_TYPE：PL/SQL对象的类型(如存储过程、函数、触发器等)
3、OBJECT_SETTING：PL/SQL对象的设定

使用方法：

1.查询指定类型PL/SQL对象的设置情况

SELECT *
FROM USER_PLSQL_OBJECT_SETTINGS
WHERE OBJECT_TYPE=’PACKAGE’

2.查询指定对象（比如：test1）的设置情况

SELECT *
FROM USER_PLSQL_OBJECT_SETTINGS
WHERE OBJECT_NAME=’TEST1′

官方英文解释

USER_PLSQL_OBJECT_SETTINGS displays information about the compiler settings for the stored objects owned by the current user. Its columns (except for OWNER) are the same as those in ALL_PLSQL_OBJECT_SETTINGS.