write a query to select name from one table which has id,name and salary from another table which has id, sal where the salary is the second maximum

3 Answers   Bosch, HireCraft, Infosys,

---

Define preparedstatement.

0 Answers  

---

How can we maintain the integrity of a database by using jdbc?

0 Answers  

---

What are the differences between statement and preparedstatement interface?

0 Answers  

---

java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }

6 Answers   CTS,

---

I have the choice of manipulating database data using a byte[] or a java.sql.blob. Which has best performance?

0 Answers  

---

What is static Synchronized method in JDBC API? Give an example?

3 Answers   3 Edge Solutions, R Systems, Sirvisetti Global Services,

---

preparedstatement p= new preparedstatement is it possible ?

10 Answers   Fidelity, IBM, Infrasys,

---

What is the reason why we need a jdbcrowset like the wrapper around resultset?

0 Answers  

---

What is metadata in java programming?

0 Answers  

---

What is the limitation of PreparedStatement and how to overcome it?

0 Answers  

---

How to create Connection interface object because it is Interface , Interface is not instansiated?

9 Answers   Aptech, CTS, HCL,

---