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 are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
what is a record in a database ? : Sql dba
Is natural join same as inner join?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Explain what is table in a database?
How can you tell the difference between an index and a view?
What if we write return in procedure?
How can you create an empty table from an existing table?
how can we submit a form without a submit button? : Sql dba
How much ram can sql express use?
Define commit, rollback and savepoint?
How do I edit a trigger in sql developer?
What normalization means?
What are all the different normalizations?
how to use regular expression in pattern match conditions? : Sql dba