Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!syros.belnet.be!news.belnet.be!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Fri, 07 Jul 2006 11:34:27 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Oracle sql completed with warnings... 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> <44ae2e9a$0$16922$626a54ce@news.free.fr> In-Reply-To: <44ae2e9a$0$16922$626a54ce@news.free.fr> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1152297271.912278@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 23 X-Complaints-To: abuse@csolutions.net Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270603 Lionel wrote: > 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. As the warning is a JDBC warning you can not see it under a product not using that JDBC connection/driver. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org