DECODE Function

[Stuart B]

I'm having problems with the following error when trying to use the DECODE function:-

ORA-00939: Too many arguments for function

Does anyone know what the upper limit is for the number of arguments, and if there is a way around it?

[debasisdas]

can you post your code for my reference please.

[amitpatel66]

Tha maximum no of components for DECODE is 255 which includes EXPR,SEARCHES,R ESULTS...

[babind]

hi this is anjan from hyd
plz check once ur code
otherwise send me ur code plz

Tha maximum no of components for DECODE is 255 which includes EXPR,SEARCHES,R ESULTS...