What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?
- 6 Answers
- 31908 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 are analytic functions in sql?
What is varray in pl sql?
What are sql procedures?
What is the mutating table and constraining table?
What is Collation Sensitivity ? What are the various type ?
Is nosql relational?
Define commit, rollback and savepoint?
How is data stored in sql?
What is sp_helptext?
how to install mysql? : Sql dba
Which is better trigger or stored procedure?
What is form and report?
What is a .db file?
What is column?
How do I run sql?
