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
- 16867 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 sql procedures and functions?
How can I tell if sql is running?
What is full form of rtm?
which tcp/ip port does sql server run on? : Sql dba
What are different types of sql?
What is a table?
Is sql the best database?
What are the constraints available in sql?
What is sql resultset?
What can you do with pl sql?
what are the differences between require and include, include_once and require_once? : Sql dba
What do you understand by pl/sql packages?
What are the parts of a sql statement?
Can we use ddl statements in stored procedure?
Does mysql_real_escape_string prevent sql injection?
