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?
Answer Posted / laxmi narayana moru
VARCHAR2() IS USED TO STORE ALPHANUMERICAL DATA WHERE AS
CHAR() IS USED TO STORE THE CHARACTERS ONLY AND WHICH IS
FIXED LENGTH DATATYPE ...
CHAR() IS PROVIDING FAST ACCESSING COMPARE WITH THE VARCHAR2
()(50%).
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
what is bdb (berkeleydb)? : Sql dba
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is a natural join?
Where not exists in sql?
How to get list of all tables from a database?
What is having clause in sql?
What are dml commands?
How is indexing done in search engines?
What is t sql used for?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is the difference between inner join and left join?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is package in pl sql with an examples?
How do I filter in sql profiler?
Can we use distinct and group by together?