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
how to increment dates by 1 in mysql? : Sql dba
What is the benefit of foreign key?
Can we call a function containing dml statements in a select query?
What are functions in sql?
What are the most important ddl statements in sql?
Is pl sql and postgresql same?
How exception is different from error?
what is a record in a database ? : Sql dba
Is record in oracle pl sql?
How do I remove sql plus from windows 10?
Does truncate table reset auto increment?
Why do we need unique key in a table?
What is the difference between partition and index?
What are the types of views in sql?
how to get help information from the server? : Sql dba