What is the difference between CHAR and VARCHAR2? If
VARCHAR2 serves the uses of CHAR why CHAR is still used and
not been discarded yet?
- 9 Answers
- 16869 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / manish ranjan
1. Char is fundamental data type. VARCHAR2 is derived one.
2. Char allocates static memory space while VARCHAR2
allocates dynamic memory.
3. Char is required to maintain compatibility with other
tools (Reporting, DWH, Data related).
4. Char is faster than VARCHAR2 (for large text).
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a recursive join sql?
What is count * in sql?
What is denormalization in a database?
Differentiate between pl/sql and sql?
Is left join same as inner join?
How does pl sql work?
What is pl sql record in oracle?
Can we delete column in sql?
What plvcmt and plvrb does in pl/sql?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is a left join?
How many types of keys are there in sql?
How do you explain an index?
What is anonymous block in sql?
What is the use of index in hive?
