Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: What is wrong with the following query?
What is trunc(timestamp,'DD') ????
Do you mean to_char(timestamp,'DD') ????
You can always add in
/*+ noparallel +*/
to avoid the error from the parallel query statement..
In article <8ncae5$ktu$1_at_nnrp1.deja.com>,
ds3_99_at_my-deja.com wrote:
> Hi,
>
> What is wrong with the following query?
>
> SELECT TRUNC(t173.timestamp,'DD'), COUNT(t173.id)
> FROM tableA t173
> GROUP BY TRUNC(t173.timestamp,'DD') ORDER BY 1 ASC;
>
> I use Oracle 8.1.6.1.0/Solaris 2.6, and get the following error:
>
> ORA-12801: error signaled in parallel query server P000
> ORA-00979: not a GROUP BY expression
>
> Is this a problem with the Oracle version? Is there a fix for this?
>
> Thanks in advance for your inputs.
>
> - ds
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Aug 16 2000 - 08:04:33 CDT