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
- 18661 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 write pl sql program in mysql command prompt?
What are the 3 modes of parameter?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What is structural independence and why is it important?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
what are the different type of sql's statements ? : Sql dba
What is sql mysql pl sql oracle?
What is pl sql block in dbms?
Explain the update statement in sql
What are sql queries used for?
What is foreign key and example?
How many sql are there?
Can two tables have same primary key?
What is cte?
How to run pl sql program in mysql?
