Interested to Buy Any Domain ? << Click Here >> for more details...
PL/SQL allocates memory for the variable's at runtime or at
compile time
- 3 Answers
- 7079 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
explain mysql aggregate functions. : Sql dba
What is before trigger?
What is thread join () in threading?
What is rowid in sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is the difference between a procedure and a function?
Does mysql_real_escape_string prevent sql injection?
Can we use loop in sql?
What has stored procedures in sql?
What is flag in sql?
What is using in sql?
What are the datatypes available in pl/sql ?
What is a table in a database?
What is a pdo connection?
What are the operators in sql?
