Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿âÃüÃû¹æ·¶

1 Ä¿µÄ
¹æ·¶Êý¾Ý¿â¸÷ÖÖ¶ÔÏóµÄÃüÃû¹æÔò¡£
2 Êý¾Ý¿âÃüÃûÔ­Ôò
2.1 Êý¾ÝÎļþ
Èç¹ûÊý¾Ý¿â²ÉÓÃÎļþϵͳ£¬¶ø²»ÊÇÂãÉ豸£¬Ô¼¶¨ÏÂÁÐÃüÃû¹æÔò£º
1)Êý¾ÝÎļþÒÔ±í¿Õ¼äÃûΪ¿ªÊ¼£¬ÒÔ.dbfΪ½áβ£¬È«²¿²ÉÓÃСдӢÎÄ×Öĸ¼ÓÊý×ÖÃüÃû¡£Èç¸Ã±í¿Õ¼äÓжà¸öÊý¾ÝÎļþ£¬Ôò´ÓµÚ2¸öÊý¾ÝÎļþ¿ªÊ¼£¬ÔÚ±í¿Õ¼äÃûºó¼Ó_¡£
Àý£º¶Ôsystem±í¿Õ¼äµÄÊý ......

Oracle ¼ì²éÃüÖÐÂʵÄSQL

ÔÚÊý¾Ý¿âÆô¶¯2Сʱºó£¬¿ÉÒÔͨ¹ýÒÔÏÂSQLÀ´²âÊÔÊý¾Ý¿âÐÔÄÜ
1.  »º³åÇøÃüÖÐÂÊ:
»º³åÇøÃüÖÐÂʱíʾÔÚ²»ÐèÒª½øÐдÅÅÌ·ÃÎʵÄÇé¿öÏÂÔÚÄÚ´æ½á¹¹ÖÐÕÒµ½³£ÓÃÊý¾Ý¿éµÄƵÂÊ
select (1-(sum(decode(name, 'physical reads',value,0))/(sum(decode(name, 'db block gets',value,0))
        ......

jdbc sqlserver oracle Çý¶¯ÎÊÌ⼯½õ

ojdbc14.jarÓëclasses12.jarÓÐÊ²Ã´Çø±ð??
×î½üÓÃclasses12.jar£¬hibernate3.1ÀÏÊdzöÎÊÌ⣿
ÎÒµÄoracle9.2.0.10!
ÔÚÍøÉÏÕÒ£¬·¢ÏÖÓÐÈËÓÃojdbc14.jar¿ª·¢£¬Ã»ÓÐÓùýÄØ£¿¿´oracleµÄreadme.txtҲûÓп´Ê²Ã´ÄØ£¿
ÄÇλ´ó¸çÖªµÀ˵һÏ£¡Ê®·Ö¸Ðл£¡
------------------------------------------------------------------------- ......

Oracle·ÖÇø(Partition)

ÏîÄ¿ÖÐÓõ½µÄpartition£¬×ܽáÕûÀíÒ»ÏÂÏà¹ØÖªÊ¶¡££¨ÍøÉϲɼ¯£¬ÈçÓÐÇÖȨ£¬Ç뼰ʱÁªÏµ¡££©
 
Ò»¡¢Oracle·ÖÇø¼ò½é
ORACLEµÄ·ÖÇøÊÇÒ»ÖÖ´¦Àí³¬´óÐÍ±í¡¢Ë÷ÒýµÈµÄ¼¼Êõ¡£·ÖÇøÊÇÒ»ÖÖ“·Ö¶øÖÎÖ®”µÄ¼¼Êõ£¬Í¨¹ý½«´ó±íºÍË÷Òý·Ö³É¿ÉÒÔ¹ÜÀíµÄС¿é£¬´Ó¶ø±ÜÃâÁ˶Ôÿ¸ö±í×÷Ϊһ¸ö´óµÄ¡¢µ¥¶ÀµÄ¶ÔÏó½øÐйÜÀí£¬Îª´óÁ¿Êý¾ÝÌṩ ......

oracle ÔÚ·Ö×éÄÚÅÅÐòµÄ·½·¨

oracle·ÖÎöº¯ÊýÊ®·ÖÇ¿´ó£¬ÎÒÃÇÖ»ÒªÕÆÎÕÕâЩ·½·¨£¬¸üÖ±½ÓµÄ˵·¨¾ÍÊÇÖªµÀÕâЩ·ÖÎöº¯ÊýµÄ×÷ÓþÍÄÜÍê³ÉºÜ¶à¹¤×÷¡£
ϱßÌù³öÕâЩº¯Êý£¬¼°¼òµ¥Ó¦Óá£
ÆäÖÐÎÒÏë¶Ôlag£¨£©ºÍlead£¨£©º¯Êý×øÏÂ˵Ã÷£ºlag£¨£©±¾ÉíÊÇÑÓºóµÄÒâ˼Ҳ¾ÍÊÇÑÓºó³öÏÖijÁеÄÊý£¬¶ølead£¨£©ÓÐÒýÁì¡¢ÁìÏȵÄÒâ˼Ҳ¾ÍÊÇÌáǰ¼¸ÐÐÏÔʾijÁÐÊý¾Ý
RANK()
dense_rank() ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ