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

What is JDBC Savepoint? How to use it?

1187


How many types of resultset are there in jdbc?

953


What are the standard isolation levels defined by JDBC?

1105


What is jdbc connection?

1074


What are the different types of statements? How we can you use preparedstatement.

948


What is the meaning of “dirty read” in the database?

1015


Explain the main method?

1022


How to check jdbc driver version in websphere?

1072


What is data source in java?

939


What are the steps required to execute a query in jdbc?

929


What is the advantage of namedparameterjdbctemplate?

948


Is jdbc an api?

1058


List the advantages of using datasource?

984


What is metadata in java programming?

998


Describe how the jdbc application works.

1011