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
- 18440 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 data profiling in sql?
Can a foreign key be a duplicate?
What are the commands used in sql?
How is a PL/SQL code compiled?
What sql does db2 use?
How do I save the results of sql query in a file?
What's the difference between inner join and left join?
What is clustered index sql?
How is sql used in oracle?
Is postgresql a server?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Are subqueries faster than joins?
Why is sql*loader direct path so fast?
What is database sql?
Can we alter stored procedure?
