ORA-00909: invalid number of arguments
571496Apr 18 2007 — edited Apr 18 2007The statement works when after THEN I put "SGA-" but as soon as I put concat function I get ORA-00909>
Thanks for your HELP!
SELECT
gl_ent,
gl_sa,
gl_acc,
gl_cc,
GL_AMT,
CASE
WHEN (gl_acc BETWEEN 8000 AND 8499) OR
(gl_acc BETWEEN 8000 AND 8999) OR
(gl_acc BETWEEN 8000 AND 8981) AND
((gl_cc BETWEEN 600 AND 647) OR
(gl_cc BETWEEN 649 AND 650) OR
(gl_cc BETWEEN 651 AND 660)OR
(gl_cc BETWEEN 700 AND 755)OR
(gl_cc BETWEEN 801 AND 802)OR
(gl_cc BETWEEN 861 AND 882)OR
(gl_cc = '648')OR
(gl_cc = '800'))
THEN (concat(' " SGA-',GL_ACC,' " '))
END AS measure
FROM F_ACCT_TRX_HIST