What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?
Answer Posted / sushant
Both CHAR and VARCHAR2 types are used to store string values but both behave very differently.
CHAR should be used to store fix length strings. String values will be space/blank padded towards right before storing on disk. If this type is used to store varibale length strings, it will waste a lot of disk space. For example we can use it to store fields where we have one character only like IS_MINOR char (1). Here we will store only 'Y' or 'N' hence it becomes a prefect candidiate for char data type.
VARCHAR2 is used to store variable length character strings. The string value's length will be stored on disk with the value itself.
Explanation with an example could be found here :
http://www.oraclebin.com/2012/11/difference-between-char-and-varchar2.html
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are data types in pl sql?
How is pl sql different from sql?
What is difference between inner join and cross join?
Why primary key is required?
Which kind of parameters cannot have a default value in pl sql?
Can we create index on primary key?
What is cursor in pl sql with examples?
Is coalesce faster than isnull?
Explain what is a view?
What is column?
How do I enable sql encryption?
What is asqueryable?
how to get a list of indexes of an existing table? : Sql dba
Determine if oracle date is on a weekend?
What is the limitation on the block size of pl/sql?