Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sqlserver to Oracle
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Sqlserver to Oracle
Divers
Thread ID:
00678830
Message ID:
00678830
Vues:
52
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