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
- 18438 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 can the performance of a trigger be improved?
How to handle bulk data?
Can we join 3 tables in sql?
Can we use ddl statements in stored procedure?
In pl/sql, what is bulk binding, and when/how would it help performance?
Does mysql support pl sql?
what does the t-sql command ident_incr does? : Transact sql
what is 'mysqladmin' in mysql? : Sql dba
What are the benefits of pl/sql packages?
List and explain the different types of join clauses supported in ansi-standard sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
How can you tell the difference between an index and a view?
How do I filter in sql profiler?
What are aggregate and scalar functions?
What are different types of triggers?
