Tag Info

Hot answers tagged


I think select 1 from dual; is a syntax error. Here's what happens on the wire: With select 1 from dual a connection's lifecycle is: Initial establishment First query (validation does not yet happen) Return to the pool Validation: the pool sends select 1 from dual The database answers: ORA-01403: no data found Next query and so on. The connection is ...


Percona wrote up a nice article MySQL Prepared Statements explaining pros and cons So there are good reasons to use prepared statements: Save on query parsing Save on data conversion and copying Avoid SQL Injection Save memory on handling blobs There are also drawbacks and chewats of using prepared statements: Query cache ...

Only top voted, non community-wiki answers of a minimum length are eligible