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
- 15744 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
Can we create clustered index without primary key?
What is the use of function "module procedure" in pl/sql?
Can we insert in view in sql?
what is a composite primary key ? : Sql dba
How do I write a sql query in pgadmin 4?
Why are sql stored procedures used?
How do you modify a table in sql?
How does a self join work?
define sql delete statement ? : Sql dba
What is the most common sql injection tool?
How do I filter in sql profiler?
How is indexing done in search engines?
Why do we need a foreign key?
Explain scalar functions in sql?
What is a database trigger?
