Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18070 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
Are subqueries better than joins?
What is relationship? How many types of relationship are there?
what is foreign key? : Sql dba
What is the non-clustered index in sql?
What is the difference between sql and t sql?
What are sql commands?
Can we have two clustered index on a table?
What is trigger in sql and its types?
When can we use the where clause and the having clause?
how to use regular expression in pattern match conditions? : Sql dba
Is sql a microsoft product?
What is user in sql?
What are sql data types?
Is nosql relational?
explain the options of myisamchk to improve the performance of a table. : Sql dba
