padma

• Oct 27th, 2005

 

           1) PREPARED statements r already pre-compiled whereas for STATEMENT, each and every statement has to be compiled all the time..

           2)  If u want to execute a single SQL statement multiple number of times, then go for PREPARED statement or else v can use STATEMENT.

          

          

              

Rajasekar

• Nov 21st, 2006

 

Statement Fixed parameter value Execute every time

Prepared Statement Can supply parameter value at execution time Execute once for ?n? parameter value

Callable Statement To execute stored procedure like pl/sql

rkrajnishraj

 Profile Answers by rkrajnishraj 

• Jan 17th, 2011

 

PreparedStatement provides facility of parameterized queries while Statement does not.

P.S is pre-compiled while Statement is not hence Statement is compiled everytime for each query request.

Statement is fast then P.S