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
- 18320 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
How to prepare for oracle pl sql certification?
How many clustered indexes can you have?
Can I learn sql in a week?
how to enter characters as hex numbers? : Sql dba
Why do we use joins?
What are expressions?
What is break?
What is trigger explain it?
What is an exception in PL/SQL? What are the two types of exceptions?
What is java sql connection?
Why do we need unique key in a table?
What is sql and also describe types of sql statements?
Cite the differences between execution of triggers and stored procedures?
how is myisam table stored? : Sql dba
What is over () in sql?
