Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: MikeDevenney
- Order by date
-
Determine the difference in days between two dates ?
GTB has left the building.- MikeDevenney
- Post #6
- Forum: Oracle: All versions
-
CASE Statement Syntax Question
Not sure if there is enough room to paste my entire statement but if I can then I think you'll see why I can't (at my skill level, at least) include the sub-select table in the from clause. One caveat, the data returned by this statement is consumed by an interface to a 3rd party system so the...- MikeDevenney
- Post #7
- Forum: Oracle: All versions
-
CASE Statement Syntax Question
Thanks for the quick replies Turk and Santa. Here's what I came up with (that seems to be working) after adding the END (thanks Santa!). I come from the other side of the fence and I'm still finding my way around in this new Oracle world... CASE WHEN imt.imt_cde_msg_type = 'MT103'...- MikeDevenney
- Post #5
- Forum: Oracle: All versions
-
CASE Statement Syntax Question
Can anyone tell me what I'm doing wrong in the statement below? The sub-select in the first WHEN block works fine when not embedded in the CASE statement but I need to add the test for the message type (MT103 vs MT202) and return a different value for BeneficiaryCustomerAccount and some (but...- MikeDevenney
- Thread
- Replies: 7
- Forum: Oracle: All versions
