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
- 16296 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 do you rank data in sql?
Is sql procedural language?
What are inner and outer joins examples of both?
What is partition by in sql?
How do I remove sql developer from windows 10?
How do you optimize a query?
What is sql catalog?
What is the difference between left join and right join?
What is the purpose of a sql?
What is the example of procedure?
What is a temporal table?
How do I remove sql plus from windows 10?
how to present a past time in hours, minutes and seconds? : Sql dba
What are the query optimization techniques?
what is the difference between delete and truncate commands? : Sql dba
