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.
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'
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments