Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Merge Statement in StoredProcedure or Not?

User_19BPUOct 7 2015 — edited Oct 7 2015

Hi,


  I have 3 merge statements , whether it is better to invoke these merge statements with in a Stored Procedure or we will invoke these merge statements separately using JDBC - PreparedStatement? Which approach is better? Since SP is a pre-compile statement and will wrap all these merge statements into a single statement whether it is be faster in this case? Please clarify.

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2015
Added on Oct 7 2015
6 comments
291 views