|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
January 31st, 2005, 05:20 AM
|
|||
|
|||
|
Case Statement in Developer 2000
I writing the following Query in the Program Unit of a developer 2000 from:
Select Sum(Case when Substr(Card_no,1,1) = '4' THEN 1 ELSE 0 END) TEST FROM RPT_CBI But when i Compile the Query it gives the error "Encountered symbol Case". Does that mean that CASE statements are not recogonized in Developer2000???
|
|
#2
January 31st, 2005, 07:16 AM
|
|||
|
|||
|
try it this way
select ...(case Substr(Card_no,1,1) when '4' then .... else ... END) as ...
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Case Statement in Developer 2000 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
