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 difference between sharding and replication?
How to convert characters to dates in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How many types of tables are there in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the differences between blob and clob in oracle?
What is concurrency in oracle?
Give syntax for SQL and ORACLE joins.
How to export your connection information to a file?
Does oracle partitioning improve performance?
how to handle exceptions in post production
How to delete a column in an existing table?
What is bulk collect in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
How to create a stored procedure in oracle?
