Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: IF-Clause in standard SQL

Re: IF-Clause in standard SQL

From: Andreas Necker <Andreas.Necker_at_isb-ka.de>
Date: Thu, 01 Mar 2001 16:40:57 +0100
Message-ID: <3A9E6D89.B85A9147@isb-ka.de>

hi,

Alexander Kaltenbrunner wrote:
>
> But what could I do if I want to sum up everything bevore one date? Is ther
> a possibility of a if-clause in standard SQL like
>

if your db is an oracle 8.1.6 you can use the new 'analytic functions':

        'sum() over ()'

-- 
Andreas Necker

ISB AG              Tel: +49 (0)721/82800-0
Karlstrasse 52-54   Fax: +49 (0)721/82800-82
76133 Karlsruhe     mailto:Andreas.Necker_at_isb-ka.de
Germany             http://www.isb-ka.de
Received on Thu Mar 01 2001 - 09:40:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US