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
- 18317 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
Can pl sql procedure have a return statement?
How many sql are there?
What is raid? How does it help storage of databases?
What is varchar data type in sql?
What are the types of join in sql?
How do you modify a trigger?
Is json a nosql?
what is self join and what is the requirement of self join? : Sql dba
which operator is used in query for pattern matching? : Sql dba
How many sql statements are used?
What is duration in sql profiler trace?
how to calculate expressions with sql statements? : Sql dba
How many unique keys can a table have?
What is the limitation on the block size of pl/sql?
How we can update the view?
