Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Group By nested too deep...
there are only 30 columns in the group by (my bad), a subtraction of two
sums in a having (difference of the two sums != 0) and an order by on the
sum of one column subtracted from the sum of another column (same columns as
were in the having).
That sql reference (funny... tahiti doesn't understand that that appendix
exists when I search on the query) says there can be 255...
Oracle support thinks it is probably a mismatched set of praens... except that when you simply eliminate the order by it runs fine.
it is a butt ugly query, but it looks syntactically correct to me...
I almost wonder if it might be...
(e) Oracle places no limit on the number of columns in a GROUP BY clause or
the number of sort specifications in an ORDER BY clause. However, the sum of
the sizes of all the expressions in either a GROUP BY clause or an ORDER BY
clause is limited to the size of an Oracle data block (specified by the
initialization parameter DB_BLOCK_SIZE) minus some overhead.
The sum of the sizes of all expressions in either... I wonder if maybe it isn't the sum of all in both...
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
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com]
Sent: Friday, March 05, 2004 9:59 AM
To: oracle-l_at_freelists.org
Subject: FW: Group By nested too deep...
Just found this:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/ap_stand
ard_sql.htm#7262
<http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/ap_stan
dard_sql.htm#7262>
-Mark
-----Original Message-----
From: Bobak, Mark
Sent: Friday, March 05, 2004 10:57 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Group By nested too deep...
April,
What version of Oracle?
What specific error?
-Mark
-----Original Message-----
From: April Wells [mailto:AWells_at_csedge.com]
Sent: Friday, March 05, 2004 10:38 AM
To: 'oracle-l_at_freelists.org'
Subject: 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.
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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Mar 05 2004 - 11:32:00 CST
![]() |
![]() |