-
编辑 删除
analyze function (RATIO_TO_REPORT)
Analyzer explains what need to do. the first SQL looks terse, but the pct will always equal 1. change to SQL 2, note the join relationship.update employees e1set pct = (select RATIO_TO_REPORT(salary) OVER () AS rr from employees e2 WHERE e1.employee_id = e2.employee_id )WHERE job_id = 'PU_CLERK';-->update employees e1set pct = (select aaa.rr from (select employee_id, rowid, RATIO_TO_REPORT(salary) OVER () AS rr from employees
-
编辑 删除
XA support
[symptom]in real time loading , it is required to support XA transaction in Oracle and MQ. When we deploy the apps to run in The following exception was thrown: The.XA.Error.is............:.-3The.XA.Error.message.is....:.A.resource.manager.error.has.occured.in.the.transaction.branch.The.Oracle.Error.code.is...:.65535The.Oracle.Error.message.is:.Internal.XA.Error [what's XA]XA is an industry standard interface between a Transaction Manager and a Resource Manager. A Resource Manager (RM) is an a
