Hi guys
DECLARE
V_num1 NUMBER := 0;
V_num2 NUMBER (4) := 0;
BEGIN
...
END;
Is there any performance gain if declare a variable as declared for V_num2. Bcos for in a annonymous block, I need a number of such (more than 100) variables to declare.
Is it V_num2 take less memory than V_num1. Or is it really does'nt matter.
Pls enlighten me.
Regards
Bhaskar