--PL/SQL块形式的:
DECLARE
iNUMBER;
njNUMBER:=0;
noNUMBER:=0;
BEGIN
FORiIN1..100LOOP
IFMOD(i,2)=1THEN
nj:=nj+i;
ELSE
no:=no+i;
ENDIF;
ENDLOOP;
dbms_output.put_line('奇数和:'||nj);
dbms_output.put_line('偶数和:'||no);
END;
/
--一句话的:
SELECTSUM(CASE
WHENMOD(rownum,2)=1THEN
rownum
END)奇数和,
SUM(CASE
WHENMOD(rownum,2)=0THEN
rownum
END)偶数和
FROMdual
CONNECTBYrownum