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
- 18666 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / satish asnani
Technically CHAR has better performance than VARCHAR2.
For CHAR(10) database already knows the length of value in
each record and therefore displays the entire string up till
10 characters. In case of VARCHAR2 the end of string has to
be reached('\0'-NULL) before the database stops displaying
the characters ahead. Each character is compared to NULL
character before it can be determined that end of string has
arrived. Comparing each string character with NULL character
consumes some CPU cycles and hence VARCHAR2 is slower in
performance as compared to CHAR.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is time based sql injection?
What is substitution variable in pl sql?
Is ms sql is free?
Can I create table without primary key?
What is difference between mysql and postgresql?
Explain normalization and what are the advantages of it?
Can a commit statement be executed as part of a trigger?
How can we link a sql database to an existing android app?
What is online transaction processing (oltp)?
Can we perform dml in function?
What is serial sql?
Can procedure in package be overloaded?
What are two statement types in sql?
explain about mysql and its features. : Sql dba
How to add, remove, modify users using sql?
