GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 5 of 249    Print  
Difference between Execute, Execute Query, Execute Update and Execute Batch.

  
Total Answers and Comments: 5 Last Update: March 04, 2009     Asked by: srinivas 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 16, 2006 23:14:22   
Prasad Meduri        

RE: Difference between Execute, Execute Query, Execute...

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.


 
Is this answer useful? Yes | No
March 02, 2006 05:11:38   
divya        

RE: Difference between Execute, Execute Query, Execute...

HI

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

Executeupdate for updating oracle.

Divya


 
Is this answer useful? Yes | No
March 06, 2006 09:25:01   
venkat        

RE:Ejb

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?


 
Is this answer useful? Yes | No
July 07, 2006 06:34:29   
Mohan Brundavanam        

RE: Difference between Execute, Execute Query, Execute...

Execute : It returns boolean value

ExecuteQuery:it returns resultset

ExecuteUpdate :It returns integer


 
Is this answer useful? Yes | No
March 04, 2009 12:11:11   
taraldesai Member Since: January 2007   Contribution: 28    

RE: Difference between Execute, Execute Query, Execute Update and Execute Batch.
Never seen in oracle
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2010 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape