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
- 18426 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / chandu
Have more diff between char and varchar2
char size only 2000 bytes in sql, default size is 1 byte.
it will occupying the trailing spaces. so much of memory wasted.
varchar2 size 4000 bytes in sql and no default size.
it will not occupying the trailing spaces.
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
How to use boolean type in select statement?
What is a heap in sql?
What is the difference between distinct and unique in sql?
how does a local variable is defined using t-sql? : Transact sql
Differentiate pl/sql and sql?
What are aggregate functions in sql?
What is sqlerrd?
Is oracle sql free?
how to check server status with 'mysqladmin'? : Sql dba
explain commit and rollback in mysql : sql dba
What are triggers in sql?
What is sql deadlock?
How do rank () and dense_rank () differ?
What is bitemporal narrowing?
Is it possible to link two groups inside a cross products after the cross products group has been created?
