java.sql.SQLException: ORA-00933: SQL command not properly ended in selecty statement

Question

I wrote query in servlet as....

"select Order_No from " + yard + "where Id= '" + idd + "'";

where yard is variable for table name and idd is variable for Id but i still get an error so please tell me my mistack and write proper query example for me...

shazin · Accepted Answer · 2013-05-23 06:05:03Z

3

No space after table name

"select Order_No from " + yard + " where Id= '" + idd + "'";

answered May 23, 2013 at 6:05

shazin

22k3 gold badges58 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dipendra Pokharel · Accepted Answer · 2013-05-23 06:24:49Z

0

I guess idd is not string, you need not write it within ''. Your code could be like this.

    "select Order_No from " + yard + "where Id=" + idd + "";

edited May 23, 2013 at 6:24

answered May 23, 2013 at 6:19

Dipendra Pokharel

5071 gold badge5 silver badges18 bronze badges

Comments

javamahi · Accepted Answer · 2013-05-23 06:39:03Z

0

I guess there is a space issue between yard and where clause. Try this "select Order_No from " + yard + " where Id='" + idd + "'";

answered May 23, 2013 at 6:39

javamahi

11 bronze badge

Collectives™ on Stack Overflow

java.sql.SQLException: ORA-00933: SQL command not properly ended in selecty statement

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related