Showing error ora-00923 from keyword not found where expected [message #415560] |
Tue, 28 July 2009 04:23  |
GURAVHARSHA
Messages: 9 Registered: July 2009 Location: Mumbai,India
|
Junior Member |
|
|
Hi
I m getting above error in below query.
SELECT
SUM(DECODE(A.DRCRTYPE, 'D', A.BRKAMT, 0)) DRAMT,
SUM(DECODE(A.DRCRTYPE, 'C', A.BRKAMT, 0)) CRAMT,
B.BANKCODE,
A.GLACCODE,
A.GLSUBACCODE
FROM FTXNACSDTL A,
FTXNACSHDR B
WHERE A.ENTRYNO = B.ENTRYNO
AND A.CTRLFLAG = 'N'
AND B.PBCONTROL IS NULL
GROUP BY A.ENTRYNO, A.GLACCODE, A.GLSUBACCODE
please help me.
Thanks
Haresh
[EDITED by LF: reformatted code and applied [code] tags]
[Updated on: Tue, 28 July 2009 04:29] by Moderator Report message to a moderator
|
|
|
|
Re: Showing error ora-00923 from keyword not found where expected [message #415563 is a reply to message #415561] |
Tue, 28 July 2009 04:31   |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Heheheh, "somewhere somewhere" 
I did reformat the code (using a utility) but didn't modify it. Reviewed it as well, but - really, what's wrong with it? Seems to be OK (at least, for my poor 4 eyes).
@GURAVHARSHA, could you, please, copy-paste your SQL*Plus session so that we could see what's going on?
[Updated on: Tue, 28 July 2009 04:32] Report message to a moderator
|
|
|
|
Re: Showing error ora-00923 from keyword not found where expected [message #415569 is a reply to message #415561] |
Tue, 28 July 2009 04:46   |
GURAVHARSHA
Messages: 9 Registered: July 2009 Location: Mumbai,India
|
Junior Member |
|
|
Thanks
Here with i m posting all query in highlighted column.
SELECT DRAMT ,
CRAMT ,
C.GLACNAME ,
D.PARTYNAME ,
A.BANKCODE
FROM
FMSTACS C, CMSTPARTY D,
(SELECT
SUM(DECODE(DRCRTYPE,'D', BRKAMT,0)) DRAMT,
SUM(DECODE(DRCRTYPE,'C', BRKAMT,0)) CRAMT,
B.BANKCODE,
A.GLACCODE,
A.GLSUBACCODE
[B]FROM FTXNACSDTL A,[/B] FTXNACSHDR B
WHERE
-- B.COCODE = :COCODE
-- AND B.DIVCODE =:DCODE
-- AND B.TXNDT BETWEEN :DATEFROM
-- AND :DATETO
-- AND B.BANKCODE = :BANKFROM
B.PBCONTROL IS NULL
-- AND :REPRINT ='N'
AND A.CTRLFLAG = 'N'
AND A.ENTRYNO = B.ENTRYNO
--AND ((:approve = '1' AND ((B.APPROVE1 IS NULL) OR (B.APPROVE1 IS NOT NULL AND B.APPROVE2 IS NULL))) OR
-- (:approve = '2' AND B.APPROVE2 IS NOT NULL) OR
-- (:approve = '0') )
GROUP BY B.BANKCODE,
A.GLACCODE,
A.GLSUBACCODE
) A
WHERE
A.GLACCODE = C.GLACCODE
AND A.GLSUBACCODE = D.PARTYCODE(+)
[Updated on: Tue, 28 July 2009 04:50] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Showing error ora-00923 from keyword not found where expected [message #415626 is a reply to message #415560] |
Tue, 28 July 2009 07:53   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
GURAVHARSHA wrote on Tue, 28 July 2009 05:23 |
SELECT
SUM(DECODE(A.DRCRTYPE, 'D', A.BRKAMT, 0)) DRAMT,
SUM(DECODE(A.DRCRTYPE, 'C', A.BRKAMT, 0)) CRAMT,
B.BANKCODE,
A.GLACCODE,
A.GLSUBACCODE
FROM FTXNACSDTL A,
FTXNACSHDR B
WHERE A.ENTRYNO = B.ENTRYNO
AND A.CTRLFLAG = 'N'
AND B.PBCONTROL IS NULL
GROUP BY A.ENTRYNO, A.GLACCODE, A.GLSUBACCODE
|
Going back to your first post, your group by does not match the selected columns.
|
|
|
|
|