problema storedprocedure
Posted by:
ogsbox :-)
Date: September 11, 2007 04:23PM
ciao a tutti,
ho un problema con una query...
devo creare una storedprocedure con case statement al suo interno (fino a qui tutto ok) ma che in base alla scelta nel case mi deve raggruppare i valori in modo differente.
esempio:
---------------------------------------------
SELECT SUM(O.chf),SUM(O.euro)
FROM Operazione O
WHERE
CASE _val
WHEN 1 THEN O.date =_date GROUP BY xxx; <--
WHEN 2 THEN MONTH(O.date)=MONTH(_date) GROUP BY yyy; <--
WHEN 3 THEN YEAR(O.date)=YEAR(_date) GROUP BY zzz; <--
END
---------------------------------------------
dovrei fare qualcosa di simile... ma cosi non funziona.
grazie
Subject
Views
Written By
Posted
problema storedprocedure
4294
September 11, 2007 04:23PM
2889
September 12, 2007 08:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.