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
- 18425 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / hannan
in char it allocates the memory space as static where as in
varchar2 it allocates the memory space as dynamic
OR
char is a space mapping function where as in varchar2 it is
not mapping the space it occupies the exact size of the
string
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
How to order siblings in oracle hierarchy queries?
What is composite data type in pl sql?
What is foreign key in sql with example?
How to select unique records from a table?
Is mariadb a nosql database?
Mention what is the plv (pl/vision) package offers?
what are sequences
How to select 10 records from a table?
How do I kill a query in postgresql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How bulk collect improves performance?
What is normalization in sql?
What are the types of index in sql?
Why use truncate instead of delete?
What is use of term?
