February 2007 - Posts

• ORACLE 中的比率计算函数

  RATIO_TO_REPORT是一个分析函数. 用来计算一个值在一系列值之间所占的比重. 语法：RATIO_TO_REPORT(列名或表达式) OVER() 下面的例子计算每一个采购员的工资在所有采购员中占的比率: SELECT last_name, salary, RATIO_TO_REPORT(salary) OVER () AS rr    FROM employees    WHERE job_id = '采购员';     结果: LAST_NAME                     SALARY         RR ------------------------- ---------- ---------- Khoo                            3100 .223021583 Baida                           2900 .208633094 Tobias                          2800 .201438849 Himuro                          2600  .18705036 Colmenares                      2500 .179856115 Posted Feb 14 2007, 06:14 PM by alex with no comments

• Resend Email For Account Request In ITMC

  1.Create a Standard Personal View that include "Account Key" in Account Request 2. Use the following URL to resend Email with an account key: http://10.107.0.10/userservices/itmc_service.aspx?Cmd=AFTERNEW&List=ACCREQ&ak=type the account key here Posted Feb 09 2007, 06:18 PM by alex with no comments