Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Albert Hopkins
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi...

I wrote



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

What I did wrong?? please
 
Swastik Dey
Rancher
Posts: 1603
5
Android Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64700
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic