jQuery in Action, 2nd edition*
The moose likes Oracle/OAS and the fly likes Error ORA-00937 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Error ORA-00937" Watch "Error ORA-00937" New topic
Author

Error ORA-00937

Deepakkumar Devarajan
Ranch Hand

Joined: Apr 19, 2011
Posts: 54

Hi All,

I get the error "ORA-00937 Not a single-group group function" when i execute the below query.



Can anyone please help....

Thanks in Advance,
Deepakumar Devarajan


Regards,
Deepakkumar Devarajan
Rajkamal Pillai
Ranch Hand

Joined: Mar 02, 2005
Posts: 443
    
    1


What happens when you execute the query/sub-query from prompt?
Deepakkumar Devarajan
Ranch Hand

Joined: Apr 19, 2011
Posts: 54

Raj Kamal wrote:
What happens when you execute the query/sub-query from prompt?


Hi Raj Kamal,

Thanks for your response, When I execute the sub queries seperately I get the actual out put... Or If I hard code the when statement conditions in the above query mentioned, I get the output.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error ORA-00937