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
- 18329 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 execution plan in sql?
What is the difference between a primary key and a clustered index?
What is data type in sql?
What is sql table?
What is sqlite used for?
Is oracle and sql same?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
explain the advantages and disadvantages of stored procedure? : Sql dba
How can a function retun more than one value in oracle with proper example?
how to convert character strings to numeric values? : Sql dba
what does the t-sql command ident_incr does? : Transact sql
What is the best free sql database?
What does 0 mean in sql?
What is the difference between database trigger and stored procedure?
define join and explain different type of joins? : Sql dba
