Ravi Kiran Pattu wrote:
Cant this thing can be done using a normal Statement ??
Yes, it definitely can be run using a Statement. However if it would be used over and over again with just the differences in literal values, then by using the PreparedStatement or CallableStatment you get the benefit of:
1) Sql injection prevention (no arbitrary strings concatenated directly into your SQL code), and
2) faster processing and higher scalability (reusing the PreparedStatement with different values of bind parameters generally saves on database processing by skipping the parse phase, which can be resource consuming and non-scalable in Oracle).