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 is relationship? How many types of relationship are there?
Is truncate ddl or dml?
What is a join?
What is the basic form of sql query?
what is a composite primary key ? : Sql dba
What are different joins used in sql?
Is sqlexception checked or unchecked?
How to get each name only once from an employee table?
How to assign sql query results to pl sql variables?
explain advantages of myisam over innodb? : Sql dba
Can we create foreign key without primary key?
Why we use joins in sql?
What are the different schemas objects that can be created using pl/sql?
Why we use join in sql?
How do I run a script in sql developer?