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
- 16868 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
How do I run a sql script?
What are user defined functions?
How do you create an update query?
how to start mysql server? : Sql dba
What is join view in sql?
What is trigger explain with example?
What is equi join in sql?
How to start the command-line sql*plus?
What type of join is sql join?
Explain the purpose of %type and %rowtype data types with the example?
discuss about myisam key cache. : Sql dba
What is the difference between explicit and implicit cursors in oracle?
How does one use sql*loader to load images, sound clips and documents? : aql loader
Is a foreign key always unique?
What are the types of queries in sql?
