FAQ

About substituting variables for parameters in pl/sql procedure

Author: asktom.oracle.com
Category: Oracle FAQ
Comments (0)

Hello,Tom! If a procedure is run frequently, does substituting variables for parameters in pl/sql procedure make the procedure run faster? For example,I see code like below: Procedure1: CREATE OR REPLACE PROCEDURE useVariable(para1 in V...

Read More...

Sponsored Links

Read Next: Stored procedures vs Java Prepared statements

Comments

Subscribe via RSS

Subscribe to GeekArticles.com by Email

Enter your email address:

Subscribe in a reader

Oracle FAQ

Synchronize data from remote location
Oracle Fundamentals
How to connect SQLPlus without tnsnames.ora
Best Practices for App Server Keep Alive
bind variables in triggers
how to avoid outer joins
One 900 column table versus ten 90 column tables.
Does select generate undo ?
Performance Question
Help analyze statspack report

About substituting variables for parameters in pl/sql procedure

Comments

Post Your Comment:

Subscribe via RSS

Oracle FAQ

Sponsored Links