Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18680 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / madhavi
Hi,
Char is the datatype that occupies complete space declared
whether used or not. ie:- If any field is declared as char
(10) then this field for all records will occupy complete
10 bytes whether the value stored in it is 1 byte or 10
byte.
Whereas Varchar2, as the first 3 characters explains Var-
Variable, will occupy only the bytes for the value entered
in the field.
So ideally it is good practice to declare fields like
emp_flg or any other fields which we are sure will have
fixed length value as Char.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How is data stored on a disk?
What is latest version of sql?
What is oracle and pl sql?
How does sql*loader handles newline characters in a record? : aql loader
Can a varchar be a primary key?
what is sql server agent? : Sql dba
what are all different types of collation sensitivity? : Sql dba
how to show all tables with 'mysql'? : Sql dba
what happens if null values are involved in expressions? : Sql dba
List out the acid properties and explain?
What is Difference Between Unique and Primary Key Constraints?
What is a unique key?
What is pl sql code?
What is the difference between the conventional and direct path loads? : aql loader
What is the difference between cross join and natural join?
