oracle deterministic关键字
http://inthirties.com:90/viewthread.jsp?tid=1395
这个deterministic是不是很眼熟呀，
我们在online redefinition里见到过这个关键字，这个关键在在自定义的函数索引里也出现了。
先看看文档
DETERMINISTIC Clause
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 reexecuting 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 function.
The following semantic rules govern the use of the DETERMINISTIC
clause:
*You can declare a top-level subprogram DETERMINISTIC.
*You can declare a package-level subprogram DETERMINISTIC in the
package specification but not in the package body.
*You cannot declare DETERMINISTIC a private subprogram (declared
inside another subprogram or inside a package body).
*A DETERMINISTIC subprogram can call another subprogram whether the
called program is declared DETERMINISTIC or not.
要实现自己的函数，加入函数索引，必须加入这个deterministic关键字，保证你这行的返回是一个确定数。
否则出现
30553, 00000, “The function is not deterministic”
// *Cause: The function on which the index is defined is not
deterministic
// *Action: If the function is deterministic, mark it
DETERMINIS
相关文档：
好长时间没写东东了，今天写了一个oracle的分页存储过程，贴出来与大家分享。
由于。net框架中的gridview等控件的分页功能太弱，所以大部分程序员都会自己写分页功能，而调用分页存储过程是必须的。
前台aspx页面不管是用下载的dll还是用自己写的用户控件，都能实现自己的功能，然而分页的存储过程就需要好好的考虑了，下 ......
Actions
Every action belongs to an action type. An action type is a collection of actions having similar functionality. For example, actions in the absolute-job-level action type all require approvals up to a certain job level in the HR supervisory hierarchy.
每个行为都属于一种行为类型。每种行为类 ......
Oracle触发器语法(一)
一 Oracle触发器语法
触发器是特定事件出现的时候，自动执行的代码块。类似于存储过程，触发器与存储过程的区别在于:存储过程是由用户或应用程序显式调用的,而触发器是不能被直接调用的。
功能：
1、 允许/限制对表的修改
2、 自动生成派生列，比如自增字段
3、 强制数据一致性
4、 提供审计� ......
1.基本结构
CREATE OR REPLACE PROCEDURE 存储过程名字
(
参数1 IN NUMBER,
参数2 IN NUMBER
) IS
变量1 INTEGER :=0;
变量2 DATE;
BEGIN
END 存储过程名字
2.SELECT INTO STATEMENT
将select查询的结果存入到变量中，可以同时将多个列存储多个变量中，必须有 ......
函数:
字符函数
转化成小写LOWER(<C>) 转化成大写UPPER(<C>) select lower('aAbBcC') from dual;
--------
日期函数
add_months(D,<I>)返回日期D加上i个月后的结果
select add_month(sysdate,3)from dual;
&nb ......
