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
- 15723 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / pradeep
in char it allocates the memory space as static where as in
varchar2 it allocates the memory space as dynamic.
Another difference is accessing a variable declared as char
is faster than, accessing a varchar2. So CHAR is still used
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between sum and count in sql?
how to escape special characters in sql statements? : Sql dba
How to pipe multiline string to isql?
What is a nested table in word?
What is meant by truncate in sql?
what is single byte over head in oracle..?
What is secondary key?
what is bdb (berkeleydb)? : Sql dba
How would you convert date into julian date format?
How does a self join work?
How to use transactions efficiently : transact sql
What are the different types of dbms?
what is the difference difference between procedure and packages
what are date and time data types? : Sql dba
Is sql better than excel?
