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
- 18417 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 do I send sql query results to excel?
What is the difference between cluster and non-cluster index?
How can we implement rollback or commit statement in a trigger?
What is crud stand for?
What is the best sql course?
what are the advantages and disadvantages of views in a database? : Sql dba
what are different types of collation sensitivity? : Sql dba
Describe sql comments?
How to call a javascript function from pl sql?
How do I count records in sql?
What does sign mean sql?
what is sql profiler? : Sql dba
What is cascade in sql?
how to drop an existing table in mysql? : Sql dba
How do you create a db file?
