ITPub博客

首页 > 数据库 > Oracle > Oracle Deterministic Function

Oracle Deterministic Function

原创 Oracle 作者:chncaesar 时间:2013-12-04 13:22:09 0 删除 编辑
Specify DETERMINISTIC to indicate that the function returns the same result value whenever it is called with the same values for its arguments.

You must specify this keyword if you intend to call the function in the expression of a function-based index or from the query of a materialized view that is marked REFRESH FAST or ENABLE QUERY REWRITE. When Oracle Database encounters a deterministic function in one of these contexts, it attempts to use previously calculated results when possible rather than re-executing the function. If you subsequently change the semantics of the function, you must manually rebuild all dependent function-based indexes and materialized views.

Do not specify this clause to define a function that uses package variables or that accesses the database in any way that might affect the return result of the function. The results of doing so will not be captured if Oracle Database chooses not to reexecute the functi

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

下一篇: DBMS_Utility学习
请登录后发表评论 登录
全部评论

注册时间:2013-07-30

  • 博文量
    102
  • 访问量
    900146