Solved

case when between teradata and oracle

Posted on 2010-11-18
4
1,069 Views
Last Modified: 2013-11-11
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'))
0
Comment
Question by:it-rex
  • 3
4 Comments
 
LVL 31

Accepted Solution

by:
awking00 earned 500 total points
Comment Utility
Case
         When  (Length(Trim(Cl_Pro.Prog)) = 5
   And    SUBSTRING(Cl_Pro.Prog,1,1) = '7'
   And   Cl_Pro.SUgt In('01', '08', '27'))
then <some value or expression>
end
0
 
LVL 31

Expert Comment

by:awking00
Comment Utility
Sorry, Oracle syntax is SUBSTR not SUBSTRING
0
 
LVL 11

Author Closing Comment

by:it-rex
Comment Utility
thanks
0
 
LVL 31

Expert Comment

by:awking00
Comment Utility
Glad to help :-)
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now