getting java.sql.SQLSyntaxErrorException: ORA-00936: missing expression error

Question

I'm using JDBC to connect to the Oracle database and ask how many methods are in the String class. I keep getting the following error:

Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at the following line:

ResultSet res1 = stmt.executeQuery("SELECT (Distinct method_name) FROM all_java_method WHERE name LIKE 'String' Order BY method_name");

I don't have a ton of experience with SQL yet so any help would be appreciated. Thanks.

try substitute (Distinct method_name) with Distinct method_name and 'String' with 'String%' or '%String%' — Alexander
– Alexander, Commented Feb 15, 2014 at 23:16

Alexander · Accepted Answer · 2014-02-15 23:25:59Z

2

Substitute (Distinct method_name) with Distinct method_name because that is the correct syntax for the SELECT
Also, you need to substitute 'String' with 'String%' or '%String%' (depends on what exactly are you wanna fetch, I don't know java, so...), otherwise it is logicaly become equal to name = 'String'

answered Feb 15, 2014 at 23:25

Alexander

3,1992 gold badges21 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

getting java.sql.SQLSyntaxErrorException: ORA-00936: missing expression error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related