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

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.
ÿ¸öÐÐΪ¶¼ÊôÓÚÒ»ÖÖÐÐΪÀàÐÍ¡£Ã¿ÖÖÐÐΪÀàÐͶ¼ÊǾßÓÐÏàËÆ¹¦ÄܵÄÐÐΪ¼¯ºÏ¡£ÀýÈ磬ÊôÓÚ¾ø¶Ôְλ¼¶±ðµÄÐÐΪ¶¼ÐèÒªÏòÉÏͨ¹ýÈËÁ¦×ÊÔ´¹ÜÀí²ã´ÎÖеÄij¸ö¹Ì¶¨Ö°Î»¼¶±ðµÄÉóÅú
Ò»£®Action Type  ÐÐΪÀàÐÍ
1£®    Action-Type Name  ÐÐΪÀàÐÍÃû×Ö
2£®    Action-Type Handlers  ÐÐΪÀàÐ;ä±ú
3£®    Action-Type Descriptions  ÐÐΪÀàÐÍÃèÊö
4£®    Allowed Rule Types  ÔÊÐíµÄ¹æÔòÀàÐÍ
5£®    Allowed Approver Types  ÔÊÐíµÄÉóÅúÀàÐÍ
6£®    Order Numbers   ÐòºÅ
7£®    Chain-of-Authority Ordering Modes  ÉóÅúÁ´µÄÅÅÐòģʽ
8£®    Voting Regimes  ͶƱ¹æÔò
¶þ£®Required Attributes  ÐèÒªµÄÊôÐÔ
Èý£®Actions   ÐÐΪ
Action Type
Chain Structure for HR Employee (Person) Approver Type
absolute job level  ¾ø¶Ôְλ¼¶±ð
The chain ends with one or more approvers at, just under, or above a fixed job level.
  ÉóÅúÁ´ÔÚijһ¹Ì¶¨Ö°Î»ÉÏϵÄÒ»¸ö»ò¶à¸öÉóÅúÈ˽áÊø
relative job level Ïà¶Ôְλ¼¶±ð
The chain ends with one or more approvers at, just under, or above a job level a fixed number of levels above the requestor's job level.
ÉóÅúÁ´ÔÚÇëÇóÈËÖ®ÉϵĶà¸ö¹Ì¶¨Ö°Î»ÉÏϵÄÒ»¸ö»ò¶à¸öÉóÅúÈ˽áÊø
manager then final approver  ¾­Àí—×îÖÕÉóÅúÈË
The chain includes the first and last approvers in the chain that would be generated by a similar absolute or relative-job-level action.
ÉóÅúÁ´°üº¬µÚÒ»ÉóÅúÈ˺Í×îÖÕÉóÅúÈË£¬¿ÉÒÔͨ¹ý´´½¨Ò»¸öÀàËÆµÄ¾ø¶Ô»òÏà¶Ôְλ¼¶±ðÀ´ÊµÏÖ¡£
final approver only  ½ö½ö×îÖÕÉóÅúÈË
The chain includes just the last approver in the chain that would be generated by a similar absolute or relative-job-level action.
ÉóÅúÁ´½ö½ö°üº¬×îÖÕÉóÅúÈË£¬¿ÉÒÔͨ¹ýÒ»¸öÀ


Ïà¹ØÎĵµ£º

Oracle 10g RAC On Linux Using NFS

http://inthirties.com:90/thread-918-3-1.html
This article describes the installation of
Oracle 10g release 2 (10.2.0.1) RAC on Linux (Oracle Enterprise Linux
4.5) using NFS to provide the shared storage.
Introduction
Download Software
Operating System Installation
Oracle Installation Prereq ......

¹ØÓÚoracleѧϰ,¶ÔÕÒ×ÊÁϽ׶εÄÓÐÒâÒå

ƽʱ½Ó´¥mysql½Ï¶à£¬ÒòΪmysqlÔÚÒ»°ãµÄСÏîÄ¿Öй»ÓÃÁË ¿ªÔ´¶øÇÒÃâ·Ñ¡£
ºÜ¶à¹«Ë¾ÐèÒªoracleά»¤µÄ£¬¿ª·¢oracleÉõÖÁÊǶþ´Î¿ª·¢ÔÚ¹úÄÚÒ²±È½ÏÉٵģ¬Óм׹ÇÎĹ«Ë¾£¬Ë­¸ÒºÍËûÃÇÇÀ·¹Íë°¡ ¹þ¹þ ²»¹ýÈ˼ҵÄÊÕ·ÑÂù¹óµÄ£¬ÄãÈç¹ûÓÐˮƽ£¬³Ôµã²Ð¸þµÄ»ú»áÂù¶à¡£ oracleµÄÅàѵÐÅÏ¢±í´ïÁËÊг¡ÐèÇó¡£
£¨ÎÒÔÚѧУ»·¾³µÄ²ÂÏ룬רҵÈËÊ¿À´ÅÄש ......

oracleÖÐÈ¥ÖØ¸´¼Ç¼,²»ÓÃdistinct

ÓÃdistinct¹Ø¼ü×ÖÖ»ÄܹýÂ˲éѯ×Ö¶ÎÖÐËùÓмǼÏàͬµÄ£¨¼Ç¼¼¯Ïàͬ£©£¬¶øÈç¹ûÒªÖ¸¶¨Ò»¸ö×Ö¶ÎȴûÓÐЧ¹û£¬ÁíÍâdistinct¹Ø¼ü×Ö»áÅÅÐò£¬Ð§Âʺܵ͡£
select distinct name from t1 ÄÜÏû³ýÖØ¸´¼Ç¼£¬µ«Ö»ÄÜȡһ¸ö×ֶΣ¬ÏÖÔÚҪͬʱȡid,nameÕâ2¸ö×ֶεÄÖµ¡£
select distinct id,name from t1 ¿ÉÒÔÈ¡¶à¸ö×ֶΣ¬µ«Ö»ÄÜÏû³ýÕâ2¸ö×Ö¶ ......

Oracle Db10g ±í

   ±íÊÇOracleÊý¾Ý¿â×î»ù±¾¶ÔÏñÖ®Ò»£¬Ëü´æ´¢Êµ¼ÊÊý¾Ý£¬ÓÉÐкÍÁÐ×é³ÉÒ»¸ö¶þά±í¡£
   ±íºÍÁеÄÃüÃûÒªÇó:
   1.³¤¶È±ØÐëÔÚ30¸ö×Ö½ÚÖ®ÄÚ£¬×î¶Ì³¤¶È²»ÄÜÉÙ1¸ö×Ö½Ú
   2.±ØÐëÊÇ×Öĸ¿ªÍ·
   3.ÄܰüÀ¨×Öĸ¡¢ÊýÖµ¡¢Ï»®Ïß¡¢»õ±Ò·ûºÅ¡£½¨Òé×îºÃ²»ÒªÓûõ±Ò·ûºÅ
 &n ......

oracle function¿ª·¢

ORACLE º¯Êý¿ª·¢
1¡¢½¨Á¢º¯ÊýµÄÓï·¨£º
  CREATE [OR REPLACE] FUNCTION º¯ÊýÃû
  [ (arg1 [mode] datatype[,........])]  --µ±Ö¸¶¨²ÎÊýÊý¾ÝÀàÐÍʱ£¬²»ÄÜÖ¸¶¨Æä³¤¶È¡£modeÖµ£ºIN¡¢OUT¡¢IN OUT£¬µ±mode Î´Ö¸¶¨Ê±£¬±íʾΪIN
 
  RETURN datatype       ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ