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 an emotional trigger?

0 Answers  

---

What is the difference between row level and statement level trigger?

0 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---

Can we use joins in subquery?

0 Answers  

---

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

what is an extent ? : Sql dba

0 Answers  

---

What is serial sql?

0 Answers  

---

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

---

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

What is latest version of sql?

0 Answers  

---