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
- 18419 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / manish ranjan
1. Char is fundamental data type. VARCHAR2 is derived one.
2. Char allocates static memory space while VARCHAR2
allocates dynamic memory.
3. Char is required to maintain compatibility with other
tools (Reporting, DWH, Data related).
4. Char is faster than VARCHAR2 (for large text).
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the different types of constraints?
What is exception? What are the types of exceptions?
What is clustered and nonclustered index in sql?
How to run sql statements through the web interface?
how to drop an existing table in mysql? : Sql dba
What is left inner join in sql?
How do I audit the sql sent to the server?
What is string join?
how to create a new table in mysql? : Sql dba
What are the possible values for the boolean data field?
What is sql used for?
what is offset-fetch filter in tsql? : Transact sql
How to display the records between two range in Oracle SQL Plus?
What are joins in sql?
What is pivot table in sql?
