Oracle Deterministic Function
来源:互联网 发布:java mysql 时区设置 编辑:程序博客网 时间:2024/06/05 18:40
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 re-execute the function.
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 re-execute the function.
0 0
- Oracle Deterministic Function
- oracle 中的deterministic
- Oracle中的DETERMINISTIC
- mysql This function has none of DETERMINISTIC-
- ORA-30553: The function is not deterministic
- deterministic
- This function has none of DETERMINISTIC, NO SQL的解决
- 函数索引 ORA-30553: The function is not deterministic 解决方法
- MySQL ERROR:This function has none of DETERMINISTIC, NO SQL
- This function has none of DETERMINISTIC, NO SQL解决办法
- ERROR 1418 (HY000): This function has none of DETERMINISTIC
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- This function has none of DETERMINISTIC, NO SQL解决办法
- Struts工作流程
- JS编码
- wxpython画板例子
- ubuntu安装p7zip
- Open the Android native Camera using OpenCV
- Oracle Deterministic Function
- make module失败的原因cc1: error: unrecognized command line option "-m64"
- Hadoop集群问题汇总
- get values of particular key in nsdictionary
- Oracle Scalar Subquery Cache
- joined-subclass和union-subclass区别
- 【翻译】Siesta事件记录器入门
- mono touch :Creating iOS Applications in Code
- 百度地图API地点搜索-获取经纬度