From: "Didier Wiroth" <dont_reply@please.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server
References: <4374839d$1@news.vo.lu> <43748653$0$26293$626a14ce@news.free.fr>
Subject: Re: regrouping 4 sql (count) queries into 1 query with a group by, howto?
Date: Fri, 11 Nov 2005 14:25:39 +0100
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 194.154.205.201
Message-ID: <43749bb7$1@news.vo.lu>
X-Trace: news.vo.lu 1131715511 194.154.205.201 (11 Nov 2005 14:25:11 +0200)
Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.vmunix.org!npeer.de.kpn-eurorings.net!news.vo.lu!not-for-mail
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:123261 comp.databases.oracle.server:255218

Yep, :-)) got it thx!

> Yes it is possible, have a look at CASE expression:
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/expressions5a.htm#1033394
>
> Regards
> Michel Cadot
>
>