Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SqlServer To Oracle
Message
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Titre:
SqlServer To Oracle
Divers
Thread ID:
00678818
Message ID:
00678818
Vues:
61
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform