Compilation of Views and PL/SQL Program Units【每日一译】--2013-1-10

最新推荐文章于 2015-03-19 13:12:02 发布

翻译最新推荐文章于 2015-03-19 13:12:02 发布 · 519 阅读

收录于

本文详细阐述了PL/SQL程序单元和视图在编译过程中必须满足的条件，包括定义正确性、引用对象的存在性和结构符合性以及拥有者权限等关键要素。

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程序单元可以被编译并且变为可用的如果以下的条件都满足的：

#视图或者程序单元的定义必须正确。所有的SQL和PL/SQL语句必须正确的构造。

所有相关的对象必须存在并且在预期的结构里。比如，如果视图的定义查询包含

一列，这一列必须出现在基表中。

#视图或者程序单元的拥有者必须拥有必要的权限对于涉及的相关对象。比如，如果

一SQL语句在一个过程中插入一行到一个表，存储过程的拥有者必须拥有插入的权限

对于相关的表。