Difference between Execute, Execute Query, Execute Update and Execute Batch.

Showing Answers 1 - 6 of 6 Answers

Prasad Meduri

  • Feb 16th, 2006

Exceute is issued on Command object.

It can execute any DDL or DML operation ( query is written as in the process of preparation of command)

ExecuteQuery is normally used to exeute a query and fetch the recordset based on that query.( 100% its used with select query)

ExecuteUpdate is used for any DML query operations( Insert,Update and Delete)

Try this.

  Was this answer useful?  Yes


  • Mar 2nd, 2006


I am getting Automation error System could not find the specified file  on using

Executeupdate for updating oracle.


  Was this answer useful?  Yes


  • Mar 6th, 2006

1.who implement home and remote interfaces?

2.why do we need home and rermote interfaces in Ejb?

3.can we connect bean without home and remote interfaces?

4.when we use sessionbeans and when we use Entitybeans?

5.Explain strutsflow?

6.If I used struts,jsp,servlets and ejb in some project.please tell the flow of this one? 

  Was this answer useful?  Yes

Mohan Brundavanam

  • Jul 7th, 2006

Execute : It returns boolean value

ExecuteQuery:it returns resultset

ExecuteUpdate :It returns integer

  Was this answer useful?  Yes


  • Aug 1st, 2011

Does it return only integer?

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions