ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories >> Software >> Java-Related >> Java-J2EE >> JDBC
 
 
 
Question
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?................
 Question Submitted By :: Info_vijaykumar
I also faced this Question!!     Rank Answer Posted By  
 
Answer
when we sent a sql stmt in to oracle sever the server 
splits statemts in to mutiple stmts, checks wheather valid 
or not, if it is valid it is stored in the shared pool,
 where as in the normal stmt parsing will be done every time
in prepared parsing will be done only once, naxt time 
onwards values will be sent to the place holders
 
0
Suri
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com