File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 52

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: 52

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
 
Similar Threads
Prepared statment executeQuery() error.
JDBC ORACLE - java.sql.SQLException: ORA-3160
MySQL update issue
How to populate default textarea value on select from dropdown
MultiDimenaional Array sort