Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

case when between teradata and oracle

Posted on 2010-11-18
4
Medium Priority
?
1,143 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 32

Accepted Solution

by:
awking00 earned 2000 total points
ID: 34168239
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 32

Expert Comment

by:awking00
ID: 34168248
Sorry, Oracle syntax is SUBSTR not SUBSTRING
0
 
LVL 11

Author Closing Comment

by:it-rex
ID: 34173241
thanks
0
 
LVL 32

Expert Comment

by:awking00
ID: 34173416
Glad to help :-)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

577 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