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
- 18062 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
What is function and procedure?
How to fix oracle error ora-00942: table or view does not exist
What does desc stand for?
Which is better join or inner query?
Does user triggers have entry for trigger with compilation errors?
Can 2 queries be executed simultaneously in a distributed database system?
What is inner join in sql?
How do I remove duplicates in two columns?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What are the types of join in sql?
Can we debug stored procedure?
What is foreign key and example?
What is db journal file?
Define sql delete statement.
What are the benefits of pl sql?
