A view or PL/SQL program unit can be compiled and made valid if the following
conditions are satisfied:
■ The definition of the view or program unit must be correct. All of the SQL and
PL/SQL statements must be proper constructs.

■ All referenced objects must be present and of the expected structure. For example,
if the defining query of a view includes a column, the column must be present in
the base table.

■ The owner of the view or program unit must have the necessary privileges for the
referenced objects. For example, if a SQL statement in a procedure inserts a row
into a table, the owner of the procedure must have the INSERT privilege for the
referenced table.

视图与PL/SQL程序单元的编译
满足如下条件的视图与PL/SQL程序单元才能编译成功
1. 视图或 PL/SQL 程序结构的定义必须正确。SQL 及 PL/SQL 语句的语法结构必须正确
2. 所有引用对象及其结构必须满足定义的要求
3. 视图或 PL/SQL 程序结构的所有者必须具备访问引用对象的权限