Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / suri

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

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I disallow NULL values in a table?

993


Explain about column name and getter method?

1062


Why is odbc needed?

907


When do we use execute method in java jdbc?

981


Which type of JDBC driver is the fastest one?

1082


Does jdbctemplate close connection?

913


How many locking systems are there in jdbc?

1024


What is drivermanager in java?

940


What is the meaning of connection?

962


What is resultset?

994


What is jdbc in java?

920


What are the differences between resultset and rowset?

1125


What is a rollback in jdbc?

935


Explain the various types of locking system in jdbc?

877


How to connect html page to database using jdbc?

894