这条DB2语句怎么转为oracle？

Question

WITH par(BRANCH_CODE,upper_cash_no) AS(
SELECT BRANCH_CODE,upper_cash_no FROM sys_org_tmp

WHERE BRANCH_CODE= $s{sys_user_sub_branch_orgno}
UNION ALL
SELECT og.BRANCH_CODE,og.upper_cash_no FROM sys_org_tmp og,par
WHERE og.BRANCH_CODE=par.upper_cash_no)

select sum(t.STOCK_QUANTITY) as total_number
from t9_prod_stock_info t
where t.prod_code = $S{prod_code}
and t.prod_sub_code = $S{prod_sub_code}
and t.LAW_MAN=$S{sys_user_contect}
and t.orgno in(
select par.BRANCH_CODE from par)

Answer 1

WITH par(BRANCH_CODE, upper_cash_no) AS (
    SELECT BRANCH_CODE, upper_cash_no FROM sys_org_tmp
    WHERE BRANCH_CODE = :sys_user_sub_branch_orgno
    UNION ALL
    SELECT og.BRANCH_CODE, og.upper_cash_no FROM sys_org_tmp og, par
    WHERE og.BRANCH_CODE = par.upper_cash_no
)
SELECT SUM(t.STOCK_QUANTITY) AS total_number
FROM t9_prod_stock_info t
WHERE t.prod_code = :prod_code
AND t.prod_sub_code = :prod_sub_code
AND t.LAW_MAN = :sys_user_contect
AND t.orgno IN (
    SELECT BRANCH_CODE FROM par
)