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
- 15725 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 are sql injection vulnerabilities?
How can a pl sql block be executed?
Can a view be mutating? If yes, then how?
how to escape special characters in sql statements? : Sql dba
What is dynamic query?
What are the sql commands?
How do you break a loop in pl sql?
what is a database lock ? : Sql dba
What is rownum?
how to get @@error and @@rowcount at the same time? : Sql dba
Does user triggers have entry for trigger with compilation errors?
which tcp/ip port does sql server run on? : Sql dba
How many types of functions are there in sql?
What are different types of tables in sql?
What is left join in sql?
