Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why Does Group By Cause ORA-01403: no data found

Re: Why Does Group By Cause ORA-01403: no data found

From: Angelo Cavallaro <angelo.cavallaro_at_pcm.bosch.de>
Date: Thu, 12 Nov 1998 10:31:18 +0100
Message-ID: <364AAAE6.13F9@pcm.bosch.de> 





Hi Gene.



A count always refers to a group.


If you have no group by expression in your statement it is handled
implizit as a single group. But if u have a group by expression
and none of the groups is selected then no count is made.
What should be count if there is no group ?



Angelito.
Received on Thu Nov 12 1998 - 03:31:18 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US