CASE Statement Limit - Select statement
Hi All,
I am having issue while running select statment with CASE statments more than 150 . Can anyone let me know is there any limit for CASE Statement . I have more than 300 WHEN conditions to get the result. see below error message
Select
CASE
WHEN deptname ='ABC' then 'ABC'
WHEN deptname='BCD' Then 'BCD'
.
.
.
.
.
.
.
.
.
END
FROM user. dept Test.caci c
where C.ZIPcode= SUBSTR(U.zipcode, 1, 5)
Error message :
ORA-00939 too many arguments for function