Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SqlServer To Oracle
Message
General information
Forum:
Oracle
Category:
PL/SQL
Title:
SqlServer To Oracle
Miscellaneous
Thread ID:
00678818
Message ID:
00678818
Views:
62
Hi Everyone!!!
Larry Miller posted a message about the change oracle made to allow the case statement
in sql Code see Thread#661027 Message#662099.
But I am having problems in a PL/SQL Procedure.
I can't use a decode because i am trying to use code like:

sum( case
when z = 123 and y = 432
then 'hello World'
end) as SomeTotal

So I guess my question is How can I get around this?
Thanks in advance
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide

LeRoy Jackson
Next
Reply
Map
View

Click here to load this message in the networking platform