This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I have a Java Stored Procedure which I deploy to Oracle 9i database.
In one of the method I am performing the following operations: Quering a table and storing the values in varibales, befrore inserting I am truncating the table and then inserting the values into the table.
Is there any way I can optimise and improve the perfomance?