Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle deterministic¹Ø¼ü×Ö

http://inthirties.com:90/viewthread.jsp?tid=1395
Õâ¸ödeterministicÊDz»ÊǺÜÑÛÊìѽ£¬
ÎÒÃÇÔÚ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 ·ÖÒ³´æ´¢¹ý³Ì ¼¸Ê®ÍòÌõ¼Ç¼

ºÃ³¤Ê±¼äû䶫¶«ÁË£¬½ñÌìдÁËÒ»¸öoracleµÄ·ÖÒ³´æ´¢¹ý³Ì£¬Ìù³öÀ´Óë´ó¼Ò·ÖÏí¡£
ÓÉÓÚ¡£net¿ò¼ÜÖеÄgridviewµÈ¿Ø¼þµÄ·ÖÒ³¹¦ÄÜÌ«Èõ£¬ËùÒԴ󲿷ֳÌÐòÔ±¶¼»á×Ô¼ºÐ´·ÖÒ³¹¦ÄÜ£¬¶øµ÷Ó÷ÖÒ³´æ´¢¹ý³ÌÊDZØÐëµÄ¡£
ǰ̨aspxÒ³Ãæ²»¹ÜÊÇÓÃÏÂÔصÄdll»¹ÊÇÓÃ×Ô¼ºÐ´µÄÓû§¿Ø¼þ£¬¶¼ÄÜʵÏÖ×Ô¼ºµÄ¹¦ÄÜ£¬È»¶ø·ÖÒ³µÄ´æ´¢¹ý³Ì¾ÍÐèÒªºÃºÃµÄ¿¼ÂÇÁË£¬Ï ......

Oracle Approvals Management Actions

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´¥·¢Æ÷Óï·¨(Ò»)
Ò» Oracle´¥·¢Æ÷Óï·¨
´¥·¢Æ÷ÊÇÌض¨Ê¼þ³öÏÖµÄʱºò£¬×Ô¶¯Ö´ÐеĴúÂë¿é¡£ÀàËÆÓÚ´æ´¢¹ý³Ì£¬´¥·¢Æ÷Óë´æ´¢¹ý³ÌµÄÇø±ðÔÚÓÚ:´æ´¢¹ý³ÌÊÇÓÉÓû§»òÓ¦ÓóÌÐòÏÔʽµ÷ÓõÄ,¶ø´¥·¢Æ÷ÊDz»Äܱ»Ö±½Óµ÷Óõġ£
¹¦ÄÜ£º
1¡¢ ÔÊÐí/ÏÞÖƶԱíµÄÐÞ¸Ä
2¡¢ ×Ô¶¯Éú³ÉÅÉÉúÁУ¬±ÈÈç×ÔÔö×Ö¶Î
3¡¢ Ç¿ÖÆÊý¾ÝÒ»ÖÂÐÔ
4¡¢ ÌṩÉó¼Æº ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN

END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐ ......

Oracleº¯Êý

º¯Êý:
 ×Ö·ûº¯Êý 
  ×ª»¯³ÉСдLOWER(<C>)  ת»¯³É´óдUPPER(<C>) select lower('aAbBcC') from dual;
 
 --------
 ÈÕÆÚº¯Êý
  add_months(D,<I>)·µ»ØÈÕÆÚD¼ÓÉÏi¸öÔºóµÄ½á¹û
   select add_month(sysdate,3)from dual;
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ