Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sqlserver to Oracle
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Sqlserver to Oracle
Miscellaneous
Thread ID:
00678830
Message ID:
00678830
Views:
51
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