From oracle-l-bounce@freelists.org Fri Mar 5 10:00:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i25G0hV07556 for ; Fri, 5 Mar 2004 10:00:43 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i25G0fo07551 for ; Fri, 5 Mar 2004 10:00:41 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D0B9339755D; Fri, 5 Mar 2004 10:44:03 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 05 Mar 2004 10:42:24 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from smtp2.corpsys.csedge.com (unknown [12.28.86.142]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ABC79396F35 for ; Fri, 5 Mar 2004 10:36:08 -0500 (EST) Received: from CSMAIL.corpsys.csedge.com ([172.21.100.103]) by smtp2 with InterScan Messaging Security Suite; Fri, 05 Mar 2004 09:38:06 -0600 Received: by csmail.corpsys.csedge.com with Internet Mail Service (5.5.2653.19) id <19GPP5F8>; Fri, 5 Mar 2004 09:38:06 -0600 Message-ID: <0C3690346404A94CBF4DDDD4724FC614102A8BE1@csmail.corpsys.csedge.com> From: April Wells To: "'oracle-l@freelists.org'" Subject: Group By nested too deep... Date: Fri, 5 Mar 2004 09:38:04 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C402C7.D9CAA3A0" X-archive-position: 585 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: AWells@csedge.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C402C7.D9CAA3A0 Content-Type: text/plain; charset="iso-8859-1" Okay, suffice it to say that I do not understand some of the business rules that we have... HOWEVER... I have been looking through the docs in a futile attempt to figure out the answer to a question posed by one of our developers. It appears that we have a business requirement that calls for a Group by to have upwards of 50 different columns IN the group by list and it is giving her an error. I didn't know there was a limit on what you could group by (only the resulting horrendously ugly sort that would occur). Anyone have a pointer to doc on what those limits might be? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas @>-->-->-- "Few people really enjoy the simple pleasure of flying a kite" Adam Wells age 11 "Imagination is the highest kite one can fly." Lauren Bacall The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. ------_=_NextPart_001_01C402C7.D9CAA3A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Group By nested too deep...

Okay, suffice it to say that I do not understand some of= the business rules that we have... HOWEVER...

I have been looking through the docs in a futile attempt= to figure out the answer to a question posed by one of our= developers.  It appears that we have a business requirement that= calls for a Group by to have upwards of 50 different columns IN the group= by list and it is giving her an error.

I didn't know there was a limit on what you could group= by (only the resulting horrendously ugly sort that would occur). = Anyone have a pointer to doc on what those limits might be?

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
 @>-->-->--
"Few people really enjoy the simple pleasure of flying a= kite"
Adam Wells age 11
"Imagination is the highest kite one can= fly."
Lauren Bacall 

The information=
 contained in this communication, including attachments, is strictly=
 confidential and for the intended use of the addressee only; it may also=
 contain proprietary, price sensitive, or legally privileged information.=
 Notice is hereby given that any disclosure, distribution, dissemination,=
 use, or copying of the information by anyone other than the intended=
 recipient is strictly prohibited and may be illegal. If you have received=
 this communication in error, please notify the sender immediately by reply=
 e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any=
 attachment to this e-mail has been swept for viruses. We specifically=
 disclaim all liability and will accept no responsibility for damage=
 sustained as a result of software viruses and advise you to carry out your=
 own virus checks before opening any attachment.
------_=_NextPart_001_01C402C7.D9CAA3A0-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------