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
- 18450 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
How many types of index are there?
Is sql difficult?
What is pl sql collection?
List the different type of joins?
What is the difference between python and sql?
What is the life of an sql statement?
Explain sql data types?
what is a constraint? Tell me about its various levels. : Sql dba
How do I view a sql database?
What is left inner join in sql?
How does sql profiler work?
explain the delete statements in sql
What are different types of tables in sql?
What is the file extension for sql database?
What is sql integrity?
