PL/SQL allocates memory for the variable's at runtime or at compile time

PL/SQL allocates memory for the variable's at runtime or at
compile time

Question Posted / mahendra kumar garnayak

3 Answers
5890 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

PL/SQL allocates memory for the variable's at runtime or at compile time..

Answer / gaurav

For a CHAR variable, PL/SQL allocates at compile time enough memory for the maximum size.
For a VARCHAR2 variable, memory allocation depends on maximum size:
If the maximum size is less than 4,000 bytes, PL/SQL allocates at compile time enough memory for the maximum size.
If the maximum size is 4,000 bytes or more, PL/SQL allocates at run time enough memory for the actual value.

Thus, PL/SQL optimizes smaller VARCHAR2 variables for performance and larger ones for efficient memory use. ( from oracle doc)

Is This Answer Correct ?

4 Yes

0 No

PL/SQL allocates memory for the variable's at runtime or at compile time..

Answer / masthan

runtime only

Is This Answer Correct ?

2 Yes

1 No

PL/SQL allocates memory for the variable's at runtime or at compile time..

Answer / jagadeesh

compile time enough for memory allocation

Is This Answer Correct ?

0 Yes

2 No

Post New Answer