Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?
- 6 Answers
- 33685 Views
- Saama Tech, I also Faced
- E-Mail Answers
Answer Posted / sravanthi
Let us declare to variables as below:
v_empname CHAR2(10) := 'BILL';
v_depname VARCHAR2(10) := 'HRD';
the database allocates 10 bytes memory for v_empname and
just 3 bytes memory for v_deptname.
when a variable is declared varchar then the memory will be
allocated variably.
So,if one is not sure of the data that the variable is
going to hold then VARCHAR2 should be used instead of CHAR
during declaration.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
how can we find the number of rows in a table using mysql? : Sql dba
How many rows can sqlite handle?
what are all the common sql function? : Sql dba
What is the difference between an inner and outer join?
What kind of join is join?
Why do we need cursor in pl sql?
What is a full join sql?
Is progress software supports to ( pl/sql )?
Determine if oracle date is on a weekend?
How do I start sql from command line?
How to convert comma separated string to array in pl/sql?
Which table is left in left join?
How is debugging done?
