Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / gangaram
char- should be use when you know that the number of
characters in the coloumn field is constant .ex if the
gender is coloumn with char(1)- so only M and F are the two
options so char(1) is better to use than varchar2.
varchar2- first of all varchar2 is a oracle standard.
varchar2 is nothing but variable characters.
ex- if you have defined the column with varchar2(50) and
when u r inserting the record into that column with only 10
letter/characters then only 10 bits will be used instead of
50.
but if u declare char(50) full 50 bits is allocated for
that column. so even if u enter on 20 characters the space
utilized will be full 50 bits.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
what is the dual table in oracle?
How will you write a query to get a 5th rank student from a table student_report?
Explain the use of indexes option in exp command.
How to display row numbers with the records?
What is an Oracle index?
What is instant client oracle?
List the types of joins used in writing subqueries?
What are the differences between char and varchar2 in oracle?
What is parameterized cursor in oracle?
How to insert a new row into a table in oracle?
How to create additional tablespaces for an new database?
How to assign query results to variables?
Is there any function in oracle similar like group_concat of mysql?
What is the scope of a local variable?
Explain the difference between a procedure and a function?
