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
- 16871 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / hannan
in char it allocates the memory space as static where as in
varchar2 it allocates the memory space as dynamic
OR
char is a space mapping function where as in varchar2 it is
not mapping the space it occupies the exact size of the
string
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
How do I partition in sql?
Is left join faster than inner join?
How many primary keys can a table have?
What is the starting oracle error number?
How are functions and procedures called in PL/SQL?
What is %type in sql?
What are two statement types in sql?
When you have to use a default "rollback to" savepoint of plvlog?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is the difference between partition and index?
How to write pl sql program in mysql command prompt?
What is difference between group by and partition by?
What are the two types of exceptions in pl/sql?
how would you get the current date in mysql? : Sql dba
What is substitution variable in pl sql?
