Answer / samsudeen

Hi Desika, pls undesrstand the question, he/she asking the
purpose of SP.

1) Stored Procudure is a collection of sql statements
2) Faster then Sql Qury
3) Preformance Tuning
4) resuable.

Answer / desika

A Stored Procedure is used to separate business logic from
Presentation logic,advantage of implementing a business
logic as storedprocedures improves the performance and we
can use same code for the applications written in other
languages.

What is the JDBC syntax for using a literal or variable in a standard Statement?

0 Answers  

---

Why is jdbc needed?

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,

---

What are the utilities of the callablestatement?

0 Answers  

---

What are the differences between statement and preparedstatement interface?

0 Answers  

---

What is JDBC Connection isolation levels?

0 Answers  

---

How do you create Connection?

5 Answers   HCL,

---

Explain the difference between rowset vs. Resultset in jdbc?

0 Answers  

---

What is jdbc oracle thin?

0 Answers  

---

What does the jdbc driver interface do?

0 Answers  

---

Explain the steps in writing a java program using jdbc?

0 Answers  

---

What is a PreparedStatement?

3 Answers   Infosys,

---