Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?
- 6 Answers
- 33883 Views
- Saama Tech, I also Faced
- E-Mail Answers
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
How do I add a database to sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
How many sql statements are used?
what is not null constraint? : Sql dba
How show all rows in sql?
What are the benefits of pl/sql packages?
how many sql dml commands are supported by 'mysql'? : Sql dba
Can instead of triggers be used to fire once for each statement on a view?
What is procedure in pl sql?
Is a view faster than a stored procedure?
Does truncate table reset auto increment?
Which is better cte or subquery?
how to extract a unit value from a date and time? : Sql dba
How do I start sql from command line?
What is a primary key sql?
