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
- 18328 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 t-sql? : Transact sql
What schema means?
What is the difference between left outer join and left join?
What is group function in sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
What are the different ways to optimize a sql query?
What is the difference between clustered and non-clustered indexes?
Does pl sql work in mysql?
What is cost in sql execution plan?
Why do we use procedures in pl sql?
What information is needed to connect sql*plus an oracle server?
What is row_number () in sql?
explain mysql aggregate functions. : Sql dba
What are the different parts of a package?
When sql appeared?
