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
Why should I use oracle database?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to start a specific oracle instance?
what is the dual table in oracle?
Why oracle is used?
Explain the function of optimizer in oracle?
What is the difference between post-database commit and post-form commit?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Differentiate between translate and replace?
what is difference between sql plus and sql*plus? (not sql and sql plus).
Can we save images in a database and if yes, how?
What is meant by a deadlock situation?
What is oracle and what are its different editions?
How to initialize variables with default values?
