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?
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
What are the different ddl commands in sql?
What is coalesce sql?
Why is a primary key important?
What does := mean in pl sql?
Can we use views in stored procedure?
How to run sql commands in sql*plus?
What is java sql package?
What are different clauses used in sql?
What will you get by the cursor attribute sql%found?
Explain the working of foreign key?
What is a primary key sql?
What do you understand by case manipulation functions?
How exception handling is done in advance pl/sql?
What is cte?
What is example of database?