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
- 18083 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 recursive stored procedure?
Can a foreign key be a duplicate?
How to take user input in pl sql?
What is sap sql anywhere?
What are the popular database management systems in the it industry?
What are the types of dbms?
What is varchar sql?
What is sp_helptext?
How does join work in sql?
Is full outer join same as cross join?
Can we use ddl statements in stored procedure?
difference between anonymous blocks and sub-programs.
What is a system versioned table?
When is the explicit cursor used ?
Can we delete column in sql?
