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
- 18662 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
Explain select statements in sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
What operating systems are supported by oracle sql developer?
Why is %isopen always false for an implicit cursor?
What are the built in functions of sql?
Explain what is a column in a table?
What is scalar function?
Can we perform dml on view?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
How does join work in sql?
What is the difference between having and a where in sql?
how to enter numeric values as hex numbers? : Sql dba
Does sql support programming?
Which is faster count (*) or count 1?
Can sql developer connect to db2?
