SELECT transdate, prin, int, prinint, pun FROM (
SELECT d.*, rownum rn FROM (
SELECT a.transdate as transdate, nvl(a.prin,0) as prin, nvl(b.int,0) as int,
nvl(a.prin,0) + nvl(b.int,0) as prinint, nvl(c.pun,0) as pun
FROM ( SELECT trim(transdate) as transdate, sum(tranamt) as prin FROM lnsacctlist
WHERE acctno = :stLnsloanappreg.acctno AND transdate >= :acBegDate AND transdate <= :acEndDate
AND trim(memocode) in ('8001','8002','8007','8101') GROUP BY transdate ) a
FULL JOIN ( SELECT trim(transdate) as transdate, sum(tranamt) as int FROM lnsacctlist
WHERE acctno = :stLnsloanappreg.acctno AND transdate >= :acBegDate AND transdate <= :acEndDate
AND trim(memocode) in ('8003','8004','8008','8102') GROUP BY transdate ) b
ON a.transdate = b.transdate
FULL JOIN ( SELECT trim(transdate) as transdate, sum(tranamt) as pun FROM lnsacctlist
WHERE acctno = :stLnsloanappreg.acctno AND transdate >= :acBegDate AND transdate <= :acEndDate
AND trim(memocode) in ('8006') GROUP BY transdate ) c
ON b.transdate = c.transdate
ORDER BY a.transdate asc) d
WHERE rownum <= :iEndRow )
WHERE rn >= :iBegRow;这个SQL语句在PL/SQL中运行OK,但是proc中编译时报错,
Syntax error at line 3430, column 5, file csp005.sqc:
Error at line 3430, column 5 in file csp005.sqc
FULL JOIN ( SELECT trim(transdate) as transdate, sum(t
ranamt) as int FROM lnsacctlist
....1
PCC-S-02201, Encountered the symbol "FULL" when expecting one of the following: , ) union, connect, group, having, intersect, minus, order,
start, where, with,
SELECT d.*, rownum rn FROM (
SELECT a.transdate as transdate, nvl(a.prin,0) as prin, nvl(b.int,0) as int,
nvl(a.prin,0) + nvl(b.int,0) as prinint, nvl(c.pun,0) as pun
FROM ( SELECT trim(transdate) as transdate, sum(tranamt) as prin FROM lnsacctlist
WHERE acctno = :stLnsloanappreg.acctno AND transdate >= :acBegDate AND transdate <= :acEndDate
AND trim(memocode) in ('8001','8002','8007','8101') GROUP BY transdate ) a
FULL JOIN ( SELECT trim(transdate) as transdate, sum(tranamt) as int FROM lnsacctlist
WHERE acctno = :stLnsloanappreg.acctno AND transdate >= :acBegDate AND transdate <= :acEndDate
AND trim(memocode) in ('8003','8004','8008','8102') GROUP BY transdate ) b
ON a.transdate = b.transdate
FULL JOIN ( SELECT trim(transdate) as transdate, sum(tranamt) as pun FROM lnsacctlist
WHERE acctno = :stLnsloanappreg.acctno AND transdate >= :acBegDate AND transdate <= :acEndDate
AND trim(memocode) in ('8006') GROUP BY transdate ) c
ON b.transdate = c.transdate
ORDER BY a.transdate asc) d
WHERE rownum <= :iEndRow )
WHERE rn >= :iBegRow;这个SQL语句在PL/SQL中运行OK,但是proc中编译时报错,
Syntax error at line 3430, column 5, file csp005.sqc:
Error at line 3430, column 5 in file csp005.sqc
FULL JOIN ( SELECT trim(transdate) as transdate, sum(t
ranamt) as int FROM lnsacctlist
....1
PCC-S-02201, Encountered the symbol "FULL" when expecting one of the following: , ) union, connect, group, having, intersect, minus, order,
start, where, with,
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货