hai,
when to use char and varchar2....?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kranthi
char and varchar2 both we will use for character purpouse
only.but char take how many bytes we r specified in data
type size it will take that much of size.
eg: x char(10);
x:='nani' the remaining 6 character space will b wasted.
but in varchar2 we can use that 6 bytes for another
character also.
i hope so u under stood very well.
Is This Answer Correct ? | 7 Yes | 0 No |
How do you bind variables in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
"primary key=unique+null" is equal,reson?not,reason?
How to view all columns in an existing table?
What is a cluster Key ?
Write a syntax for update query in oracle?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
Is oracle a relational database?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
What is the scope of a local variable?
How to change program global area (pga) in oracle?
What is a deadlock ? Explain .