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