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
- 18665 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 is a composite key ? : Sql dba
How do I find duplicates in a single column in sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
What is a loop in sql?
What is rownum and rowid?
How do I count rows in sql?
How to change the order of columns in Oracle SQL Plus ?
Can we group by two columns in sql?
What is the difference between partition and index?
Is delete faster than truncate?
What is db journal file?
List the ways to get the count of records in a table?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is error ora-01000: maximum open cursors exceeded
What is pl sql record in oracle?
