Answer / sangeeta

Triggers are group of SQL statements which are executed
automatically in response to the DML ie. Data Manipulation
Language - insert / update / delete.

Procedures are also group of SQL statements submitted
together to the server for execution. Unlike triggers
Procedures have to be executed explicitly.

Differentiate between type_scroll_insensitive and type_scroll_sensitive.

0 Answers  

---

How a database driver can be loaded with jdbc 4.0 / java 6?

0 Answers  

---

What are the classes and methods used for sending sql statements to database?

0 Answers  

---

What is com mysql jdbc driver?

0 Answers  

---

What are static and dynamic queries?

1 Answers  

---

What is resultsetmetadata?

0 Answers  

---

Hi........I need to create a dropdown box using java.....this box should show the values that should be taken from the database...... Thank you....

1 Answers  

---

Give an example for execution of sql statement.

0 Answers  

---

What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question is when that precompiled statement will be execute or comiple?................

6 Answers   TCS,

---

What is a Connection?

1 Answers  

---

Is jdbc a web technology?

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,

---