@acfug.org
cc
Subject
RE: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
From TFM...
GROUPING SETS
GROUPING SETS are a further extension of the GROUP BY clause that let you
specify multiple groupings of data. Doing so facilitates efficient
aggregation by pruning the aggregates you do
I just updated our JDBC drivers to the latest 3.5 versions for testing out
in a dev instance. We are planning to move to Oracle 10g next Q. A
developer is seeing some errors with a query using GROUP BY GROUPING SETS.
The error is
[Macromedia][Oracle JDBC Driver][Oracle]ORA-03001: unimplemented
Can you share a sample of sql statement causing the error? Thanks.
mf
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas
Knudsen
Sent: Tuesday, February 13, 2007 3:18 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] CF, Oracle 9i
] On Behalf Of Douglas
Knudsen
Sent: Tuesday, February 13, 2007 3:29 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
darn lack of sleep. might have missed a paren or semi on the copy, but
this is the gist. The GROUPING SETS is new to me.
SELECT
] *On Behalf Of *Douglas
Knudsen
*Sent:* Tuesday, February 13, 2007 3:29 PM
*To:* discussion@acfug.org
*Subject:* Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
darn lack of sleep. might have missed a paren or semi on the copy, but
this is the gist. The GROUPING SETS is new to me
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
if only you knew the meatball. :) passed the info along. thanks. We
are able to execute this in Toad, SQL+, PL/SQL Developer, and SQL
Developer. SQL Developer uses JDBC, so seems its related to teh 3.5
To
discussion@acfug.org
cc
Subject
Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
darn lack of sleep. might have missed a paren or semi on the copy, but
this is the gist. The GROUPING SETS is new to me.
SELECT
RS.REPNAME ,
U.EMPLID ,
TO_CHAR(U.DSMDATE,'HH24
, 2007 4:32 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] CF, Oracle 9i, and GROUP BY GROUPING SETS
I know, I know, RTFM, but it has walked off. What does GROUP BY
GROUPING SETS do for you?
Are you sure that's a query, and not a novel in some foreign language?
mcg
Douglas Knudsen