it-rex
asked on
case when between teradata and oracle
I have this sql in teradata sql
how can I implement the same logic of more when condition and when condition in oracle
Case
When (Character_Length(Trim(Cl_ Pro.Prog)) = 5
And SUBSTRING(Cl_Pro.Prog
FROM 1 FOR 1) = '7'
And Cl_Pro.SUgt In('01', '08', '27'))
how can I implement the same logic of more when condition and when condition in oracle
Case
When (Character_Length(Trim(Cl_
And SUBSTRING(Cl_Pro.Prog
FROM 1 FOR 1) = '7'
And Cl_Pro.SUgt In('01', '08', '27'))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, Oracle syntax is SUBSTR not SUBSTRING
ASKER
thanks
Glad to help :-)