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
- 33907 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 friend function? : Sql dba
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
How do you use join?
how to create a new table in mysql? : Sql dba
how do you know the version of your mysql server? : Sql dba
Write a sql query to get the third highest salary of an employee from employee_table?
What are the sql commands?
What is sql query limit?
What is the basic structure of an sql?
What is t sql in sql server?
What is the difference between sql and t sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Which function is used to return remainder in a division operator in sql?
What is record in pl sql?
What is sqlite used for?
