找出所有依赖于EMPLOYEES表的对象：

找出当前模式下ORDER_MGR包依赖的所有对象

8、分析参数信息 USER_ARGUMENTS
OBJECT_NAME: The name of the procedure or function

PACKAGE_NAME: The name of the package in which the procedure or function is defined

ARGUMENT_NAME: The name of the argument

POSITION: The position of the argument in the parameter list (if 0, this is the RETURN clause of a function)

IN_OUT: The mode of the argument—IN, OUT, or IN OUT

DATA_TYPE: The datatype of the argument

DATA_LEVEL: The nesting depth of the argument for composite types (for example, if one of your arguments’ datatypes is a record, USER_ARGUMENTS will have a row for this argument with a DATA_LEVEL of 0 and then a row for each field in the record with a DATA_LEVEL of 1)

1）找出所有包含LONG参数的程序

2）找出所有带有OUT或IN OUT参数的函数。这个地方要注意一下：有经验的编程专家都会告诉我们不要在函数中仅使用IN 参数，
原因是带有OUT 和 IN OUT参数函数不能在SQL中被调用，并且不能用在函数索引中。如果你需要函数返回多块信息，那么请使用
一个存储过程或返回一个RECORD类型。下面的例子找出了违反这个条件的函数：

9 总结：这儿有座金矿
This article merely scratches the surface of the application information that can be mined from the data dictionary views in Oracle Database. PL/SQL editors such as Oracle SQL Developer provide user interfaces to many of these views, making it easier to browse their contents.

本文只是拂去了可以从Oracle数据字典视图中挖掘出的应用信息的一层表面。PL/SQL编辑器例如Oracle SQL Developer对很多 视图提供了用户接口，从而更容易的浏览它们的内容。