This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en" Watch "Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en" New topic
Author

Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en

Albert Hopkins
Greenhorn

Joined: Jul 21, 2007
Posts: 21
Hi...

I wrote



But, I got SQLException: ORA-00933: SQL command not properly ended message.

What I did wrong?? please
Swastik Dey
Rancher

Joined: Jan 08, 2009
Posts: 1477
    
    6

your sql evaluates to this

SELECT count(BLESS_SEVERITY) as sbmseverity3 from BLESS where BLESS_SEVERITY=3
AND bless_orno like '%_QSC_%' SELECT count(BLESS_SEVERITY) as no2 from bless);

and the above does not seem to be a valid sql.


Swastik
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61309
    
  66

Please take the time to choose the correct forum for your posts. This forum is for questions on JSP.

For more information, please read this.

This post has been moved to a more appropriate forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
GeeCON Prague 2014
 
subject: Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en