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
- 18069 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
what are tables and fields? : Sql dba
How can we store rows in PL/SQL using array?
Explian rowid, rownum? What are the psoducolumns we have?
how to enter binary numbers in sql statements? : Sql dba
Which join condition can be specified using on clause?
What is pl sql block in dbms?
What is difference between my sql and sql?
How many types of normalization are there?
What is sqlservr exe?
Describe types of sql statements?
What is procedure and function in sql?
What does pragma mean?
what are the advantages of mysql in comparison to oracle? : Sql dba
What is the difference between function, procedure and package in pl/sql?
What are different types of sql commands?
