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
- 16851 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
Why is there a need for sqlcode and sqlerrm variables?
What is trigger explain it?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What is the difference between nested table and varray?
what are all the different types of indexes? : Sql dba
How do I view tables in mysql?
What are all the ddl commands?
What is parallel hint?
how to drop an existing view in mysql? : Sql dba
Describe types of sql statements?
What is range partitioning?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Can you have more than one trigger on a table?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How do you remove duplicates without using distinct in sql?
