How we say that PreparedStatment is Precompiled? where it
will be compiled?
Answer Posted / natraj
Hi,
In parsings there are two types.One Hard Parsing and second
is softparsing. Firt time hard parsing will happen.That
means wheather this query is syntatically correct or not +
what is the table name,no of cols,what are the index for
that table,any sequences and foreign key related details
etc. , and firt time only hard parsing and after that it is
going to cache it at database side only,from next time
onwards only soft parsing that means only specified record
values it will retrive.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is difference between odbc and jdbc?
What is an SQL Locator?
Give steps to connect to the db using jdbc?
Name the method, which is used to prepare a callablestatement.
What is a jdbc driver and how many jdbc drivers are available?
Why prepared statements are faster?
How to retrieve warnings in jdbc?
Why “no suitable driver” error occurs?
How can we store and retrieve images from the database?
How can I retrieve a String or other object type without creating a new object each time?
Which type of driver is unique in jdbc?
How can you make the connection using jdbc?
What are types of jdbc drivers?
How data can be inserted into long row column of database?
How can you know about drivers and database information ?