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)

Answer / masthan

runtime only

Answer / jagadeesh

compile time enough for memory allocation

What is the difference between delete, truncate and drop command?

0 Answers  

---

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

---

What is the difference between partition and index?

0 Answers  

---

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

Can we insert data into materialized view?

0 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

what are the advantages of sql ? : Sql dba

0 Answers  

---

what is the difference between where clause and having clause? : Sql dba

0 Answers  

---

Can a view be mutating? If yes, then how?

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---