存储过程源码涉及到的数据字典

最新推荐文章于 2021-08-08 14:21:20 发布

原创最新推荐文章于 2021-08-08 14:21:20 发布 · 1.5k 阅读

CC 4.0 BY-SA版权

文章标签：

165 篇文章

订阅专栏

本文介绍了数据库中几种重要的视图类型，包括USER_SOURCE、ALL_ARGUMENTS、ALL_PROCEDURES和ALL_DEPENDENCIES等，这些视图有助于理解源代码、参数信息、可执行过程及对象间的依赖关系。

Name	Significance
USER_SOURCE	Includes the lines of source code for all the programs you own
ALL_ARGUMENTS	Includes information about the parameters to the procedures and functions you can call
ALL_PROCEDURES	Contains the list of procedures and functions you can execute
ALL_DEPENDENCIES	Is one of several views that give you information about dependencies between database objects.