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
- 15743 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
What is sqlca in powerbuilder?
Explain the insert into statements in sql?
What is rename command in sql?
How do you write an index?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How to select all records from the table?
What are the advantages of sql? Explain
Can you have more than one key in a database?
What are different types of queries in sql?
How to avoid duplicate records in a query?
Can we insert data into materialized view?
Is pl sql better than sql?
What is assignment operator in pl sql?
How to call shell script from pl sql procedure?
how can we submit a form without a submit button? : Sql dba
