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 the best partition size for windows 10?
How do you optimize a stored procedure query?
How to write html code in pl sql?
How to convert comma separated string to array in pl/sql?
How would you pass hints to the sql processor?
How long will it take to learn pl sql?
what is the difference between group by and order by in sql? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is indexes?
What is asqueryable?
How do I restart sql?
What is the maximum size of sqlite database?
what is table? : Sql dba
What is data definition language?