Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!proxad.net!cleanfeed3-a.proxad.net!nnrp9-1.free.fr!not-for-mail
From: "Lionel" <SPAMcoollATfreePOINTfr>
Newsgroups: comp.databases.oracle.server
References: <44abf2a8$0$1599$626a54ce@news.free.fr> <1152124027.955449.106530@v61g2000cwv.googlegroups.com> <44ace4a3$0$301$626a54ce@news.free.fr> <1152212511.336276@bubbleator.drizzle.com>
Subject: Re: Oracle sql completed with warnings...
Date: Fri, 7 Jul 2006 11:51:26 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
Lines: 15
Message-ID: <44ae2e9a$0$16922$626a54ce@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 07 Jul 2006 11:51:22 MEST
NNTP-Posting-Host: 193.253.52.139
X-Trace: 1152265882 nnrp9-1.free.fr 16922 193.253.52.139:17995
X-Complaints-To: abuse@proxad.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270549

DA Morgan wrote:
> Lets see one non-aggregated column
> One aggregated column ... COUNT(...)
> No GROUP BY clause
>
> I wonder what could be the problem. ;-)

oops sorry...
Of course there is a "group by a.column1" in my statement :)
The statement works fine and quickly.
I was just wondering why my jdbc drivers displays a warning and how I could
see the warning under sql*plus or toad.