Skip to Main Content
Forums

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!

Variable Initialization

nelsonjfrApr 8 2005 — edited Apr 11 2005
This might be a very silly question, but here it goes.

Variable Initialization.
PL/SQL, by default, initialize all variables to null.

Now:
l_variable varchar2(10);
Is equivalent to:
l_variable varchar2(10) := null;

Isn't the second initialization inefficient?.
Is there a performance issue (no matter how small) when initializing this way?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2005
Added on Apr 8 2005
7 comments
921 views