ITPub博客

首页 > 数据库 > 数据库开发技术 > Compilation of Views and PL/SQL Program Units (242)

Compilation of Views and PL/SQL Program Units (242)

原创 数据库开发技术 作者:tsinglee 时间:2007-11-24 15:43:17 0 删除 编辑

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 程序结构的所有者必须具备访问引用对象的权限

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-983758/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1900422