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

Showing Answers 1 - 10 of 10 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

divya

  • Mar 2nd, 2006
 

HI,

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

Executeupdate for updating oracle.

Divya

  Was this answer useful?  Yes

venkat

  • 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

do

  • 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.

 

Related Answered Questions

 

Related Open Questions