Solved

case when between teradata and oracle

Posted on 2010-11-18
4
1,093 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 500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Can't Access My Database 57 63
Oracle - SQL Query with Function 3 34
grant user/role question 11 28
Merging spreadsheets 8 31
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…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

785 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