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
- 15717 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / hannan
in char it allocates the memory space as static where as in
varchar2 it allocates the memory space as dynamic
OR
char is a space mapping function where as in varchar2 it is
not mapping the space it occupies the exact size of the
string
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
How to Declare Fixed Length String Value In PL SQL
Is not null in sql?
Explain lock escalation? : Transact sql
Why do we need view in sql?
What is a pragma statement?
Can procedure in package be overloaded?
What are the different type of joins in sql?
define data blocks ? : Sql dba
What is varchar example?
Why join is faster than subquery?
How do you declare a constant?
What is nosql db?
What is difference between table and view?
What does <> sql mean?
Can a foreign key be a duplicate?
