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
- 15733 Views
- Oracle, I also Faced
- E-Mail Answers
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 character functions?
Enlist the advantages of sql.
Difference between global and parameter variables?
What is the difference between sql and mysql?
what is a database transaction? : Sql dba
How to rename a column in the output of sql query?
What is the difference between null value, zero, and blank space?
how to do backup entire database? : Transact sql
How do you update a table in sql?
How to install oracle sql developer?
How do you optimize a stored procedure query?
What operating systems are supported by oracle sql developer?
What are the qualities of 2nf?
How do you exit in sql?
What is a recursive join sql?
