Problem about oracle
Statement stmt = con.createStatement();
stmt.executeUpdate("DROP TABLE Students");
stmt.executeUpdate("CREATE TABLE Students" +
"(StdNumber NUMBER primary key, StdName VARCHAR2(20),StdSurname VARCHAR2(20),Courses VARCHAR2(15), Year VARCHAR2(15),Semester VARCHAR2(5), Grades REAL )" );
stmt.executeUpdate("INSERT INTO Students" +
"VALUES (1234,'Sezgin','Zeka','Kimya','2002-2003','I',4.00)" );
ResultSet rs = stmt.executeQuery("SELECT Courses FROM Students WHERE stdNumber = 1234");
while(rs.next())
System.out.println(">>> " + rs.getString("Courses"));
}catch(Exception ex){
System.out.println("Error: " + ex);
}
Dear friend i have a problem about oracle. When i execute this code ( i have only written releated code part about my problem ) there is an error like this: Error: java.sql.SQLException: ORA-00928: missing SELECT keyword
Thanks for your help
